"Pascal Boivin" <pascal.boivin@nbautomation.com> wrote in news:NBTM8D4EB120
@nbautomation.xpd300:

> The USE command may fail with an SQL query longer than 128 bytes with
> ODBCDBE 1.90.331 and Microsoft SQL.
> 
> Before compiling the sample, open MAIN.PRG, set an appropriate SQL
> Server, then type a valid query with a few lines (at least 129 bytes).
> 
> The sample will fail at line 35
>   USE (cSQL) VIA (oSession)
> because cSQL is longer than 128 bytes.

FYI, you can use SQLExpress along side ODBCDBE. There is no problem in 
executing very long SQL statements in SQLExpress. 

Try it out, send an email to demo@sqlexpress.net with subject "sqlexpress 
demo" for download and instalation instructions.

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools