🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #207

Midas and SQL

#207
From: Aaron
Date: Sat, 05 Jun 2004 02:55
13 lines
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-mail

Show 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