-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Correct, "id" can't be blank and as you're editing a record it surely isn't blank. This means that there is a programming error; the "id" should be passed by the editing transaction. Look at the source code of the edit transaction i.e. before pressing "return". It should contain the "id" hidden field. In your case either the id field is empty or it doesn't exist at all.
To solve the problem you need to make sure that you have the correct programs matching the database structure you're currently using. You may be able to solve this particular problem by debugging the code but unless DB structure and programs are matching you bound to have further problems. Hope this helps. Bernd On Fri, 5 Nov 2010 15:08:59 -0700 Wallace Roberts Consulting <[email protected]> wrote: > Here is the complete command: > UPDATE gl SET > reference = '20100924', > description = 'fuel', > notes = '', > transdate = '2010-09-24', > department_id = 0, > curr = 'USD', > exchangerate = 1 > WHERE id = > > ERROR: syntax error at end of input > LINE 9: WHERE id = > ^ > > Obviously, the "id" cannot be blank, but I'm stumped as to why it even > would be. Ideas? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAkzUuLUACgkQpYU8M8PbPV6tPQCdHLliU1icm3ut1OGR+neM2y0C OucAn3EVcKsAl3akFWvubHYC2mANd5LX =rKfW -----END PGP SIGNATURE----- _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
