>To modify report stored in Postgres SQL server, I use in VFP 9 SP1 beta
>
>
nres=SQLEXEC(nconn, "SELECT frxcontent, frtcontent from RAPORT WHERE id=123", 'vormikirj', aRowCount )
>bytea2file( vormikirj.frxcontent, 'myreport.frx')
>bytea2file( vormikirj.frtcontent, 'myreport.frt')
>modify report myreport
>cFRX = File2ByteA( 'myreport.frx')
>cFRT = File2ByteA( 'myreport.frt')
>nRes=SQLEXEC(nconn, "UPDATE raport SET frxcontent=?cfrx," + ;
> "frtcontent=?cFRT WHERE id=123" )
>
>In modify report command, I add a new field with expression 1 and save report.
>After that error 1466 "Connection handle is invalid" occurs in SQLEXEC() line which tries to UPDATE RAPORT table.
>
>nconn has value 1 .
>If I re-create the connection, UPDATE command runs OK.
>
>This error occurs only if I run my application as .exe file
>If I run my application from VFP 9 IDE, error does not occur.
>Also, error does not occur if I build exe file using VFP 7 .
>
>Error does not occur if I only move existing field in report. Error occurs always when changing some field contents in report designer.
>This is reproducible always. I tried it in XP and Win 98 computers.
>
>
>Any idea ?
Re: Odd problem with VFP9 SP1 Beta Thread #
1053455 Message #
1055879
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up