Article View: borland.public.cppbuilder.database.multi-tier
Article #207Midas and SQL
From: Aaron
Date: Sat, 05 Jun 2004 02:55
Date: Sat, 05 Jun 2004 02:55
13 lines
1764 bytes
1764 bytes
Here is what I am trying to accomplish. I have two database tables (Customers and Product) and I have gone thru all the motions in the 'sample' turorials regarding the Master/Detail table relationship and utilizing Remote Data Providers and creating thin clients and all that, got everything working great utilizing tables, however I need to do this using SQL, here's why: Originally, my database was a stand-alone SQL query based application, now I am trying to convert it over to a multi-tiered system. Anyway, I am trying to send a query down the wire, such as a search for all records containing a certain first name. What I end up getting as a result is every record in the customer database, not the ones which match the param value (first name) passed to the server. I have the remote TQuery SQL statement checked out ok...It is almost as though the SQL query is being ignored and it is just returning the whole database....Any suggestions? Thx. in adv.
Technical Details
Message-ID:
<40c1362c$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,5090a4cef748b5a4,start X-Google-Attributes: gidfcd2b,public From: "Aaron" <info@deriveweb.ca.remove> Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Midas and SQL Date: Fri, 4 Jun 2004 22:55:59 -0400 Lines: 15 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 NNTP-Posting-Host: 69.156.208.72 Message-ID: <40c1362c$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1086404140 69.156.208.72 (4 Jun 2004 19:55:40 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail