delphi - Advantage 5400 AE_INTERNAL_ERROR -


i getting 5400 ae_internal_error when try open tadsquery after adding sql. when place same sql directly in tadsquery , there no error. file directs me contact advantage technical support r & d can fix problem. technical support suggested post here.

here snipit of code (suggested doug johnson):

if (value = '**') or (startup) dm1.qadsbsort begin   disablecontrols; := 1 26 begin   if active close;   active := false;   htext := 'select sbname, sbpath posbsorted ' +            ' [sbname ''' + chr(i + 64) + '''] ' +            ' order sbname';   sql.clear();   sql.text := htext;   try      try         screen.cursor := crhourglass;         open();               screen.cursor := crdefault;      end;    except      on e: exception      begin         if( e.message <> 'the sql statement did not '+               'generate cursor handle.  use ' +               'tadsquery.execsql execute sql ' +               'statements not select statements' )then            messagedlg( e.message, mtwarning, [ mbok ], 0 );      end;   end;   active := true; 

here system stats:

processor: intel® core™2 duo cpu @ 2.00ghz 2.00 ghz installed memory: 4.00 gb system type: 64bit. os: windows 7. programming: delphi 2010. advantage version: 9.10 64bit server: local. tables: free. please advise. thank , have day.

-bob andrews

here list of ads error codes: http://devzone.advantagedatabase.com/dz/webhelp/advantage9.1/mergedprojects/adserror/err5xxx/advantage_5xxx_error_codes.htm

error # 5400 states

this error advantage jdbc driver internal error. please send small re-creation advantage technical support demonstrating problem advantage r&d can fix issue. 

i post code on newsgroups: http://devzone.advantagedatabase.com/dz/content.aspx?key=7

or developer account , request support.


Comments

Popular posts from this blog

400 Bad Request on Apache/PHP AddHandler wrapper -

Add email recipient to all new Trac tickets -

php - Change action and image src url's with jQuery -