Using sql-commands in Paradox10

[Bubsi]

Exist a documentation about all available sql-commands in Paraodox 10 ?


For example:

In Oracle I use the command substring(field,1,5)
In Paradox this command don't work.

 

[footpad]

Bubsi,

If you're running queries against local tables (e.g. Paradox or dBASE) or you're letting BDE queries against remote tables, then you're limited to the SQL-92 subset that BDE supports.

This is documented in the LOCALSQL.HLP file, which is usually found in C:\Program Files\Common Files\Borland Shared\BDE.

Local SQL does support the SUBSTRING SQL function, but there are some caveats noted in the Help file. Specifically:

-- SUBSTRING can only be used with character columns or literals.

-- To use on values of other data types, the values must first be converted to CHAR using the CAST function.

-- The SUBSTRING function cannot be used with memo or BLOB columns.

If you're running queries against Oracle tables, you can circumvent these limitations by changing the SQLQRYMODE property of your alias to SERVER. By default, this is set to a blank value, which tell BDE to try to run queries locally and then run them on the server if those queries can't be run. By setting this property to SERVER, you by-pass that process and can improve overall performance.

Hope this helps...

-- Lance

Hope this helps...

-- Lance

 

[Bubsi]

Hello Lance,

the documentation in the LOCALSQL.HLP was helpful.

The correct command for substring(field,1,5)in Paradox is: substring(field from 1 for 5).

Thanks
Bubsi