Help from the paltalk Automated Support System
ERDPS: 1045087523.5226.5 (DO NOT DELETE THIS LINE)
What you searched for:
*, fieldname
as a select list is invalid
you'll need to list the fields completely
Alan
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of
Bj�rge S�ther
Sent: Thursday, 13 February 2003 7:46 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] TIBOQuery generating invalid SQL "under the hood"
Hello,
I'm having this problem with TIBOQuery modifying SQL under the hood,
resulting in invalid SQL:
was:
SELECT
*
FROM
INVOICE
...is modified to:
SELECT
*
, INVOICE.RDB$DB_KEY
FROM
INVOICE
...which won't compile.
I surely see what's the problem: Table 'INVOICE' does not exist.
But - what's reported is some invalid char ',' - naturally when you see what
SQL is being generated.
This must be a bug. Agreed ?
--
Bj�rge S�ther
bjorge@hahaha_itte.no
What was returned:
--------------------
[ ] FAQ_1065.htm
1) How to Create your Own Group
--------------------
[ ] FAQ_1043.htm
2) PalTalk Plus Payment Information
--------------------
[ ] FAQ_1051.htm
3) Joining a Group
--------------------
[ ] FAQ_1044.htm
4) PalTalk Beta Information
--------------------
[ ] FAQ_1063.htm
5) PalTalk without Banners
--------------------
[ ] FAQ_1049.htm
6) Sending a friend an invitation to join PalTalk
--------------------
[ ] FAQ016.html
7) Sending Voice Mail
--------------------
[ ] FAQ037.html
8) Editing User Information
--------------------
[ ] FAQ075.html
9) How to ADD/REMOVE Missing Multimedia Components
--------------------
[ ] FAQ_1047.htm
10) Making a One on One Video Call on PalTalk



Received: Wed Feb 12 14:05:23 PST 2003
Response: Wed Feb 12 14:05:24 PST 2003


[Non-text portions of this message have been removed]