Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 3 of 3 total |
Table/Column name as parameter |
Thu, Jan 12 2006 8:43 PM | Permanent Link |
Qing | In DBISAM Version 3, I could pass table or column names as parameter, for example
SELECT * FROM :TableName Parameters: ('People') But I get an error in DBISAM 4: DBISAM Engine Error # 11949 SQL parsing error - Expected table name but instead found 'People' Is there anyway to work around this problem? |
Fri, Jan 13 2006 10:09 AM | Permanent Link |
"Ralf Mimoun" | Qing wrote:
> In DBISAM Version 3, I could pass table or column names as parameter, > for example SELECT * FROM :TableName > Parameters: ('People') > > But I get an error in DBISAM 4: DBISAM Engine Error # 11949 SQL > parsing error - Expected table name but instead found 'People' > > Is there anyway to work around this problem? Generate the statement in code, eg. in OnBeforeOpen. I do that all the time via Format() and use parameters only if there is no nother way, eg. for BLOB values. Ralf |
Fri, Jan 13 2006 3:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Qing,
<< In DBISAM Version 3, I could pass table or column names as parameter, for example SELECT * FROM :TableName Parameters: ('People') >> You have never been able to use parameters for table names in DBISAM. You can only use parameters in the WHERE or JOIN clauses in places where you would normally use a constant value. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |