craftleft.gif (3002 bytes)QuickTable
Home | API | Tutorial | Download | Support | Contact topblack.gif (108 bytes)


QuickTable User Cp  |  Register  |  Members  |  Search  |  Help
    |- QuickTable Discussion Forums > General QuickTable Support/Help Post New Topic   Post A Reply
Data not updated in database printer friendly version
next newest post | next oldest post
Author Messages
jamen
Unregistered
Edit or delete this message Reply w/Quote
Posted Tuesday, September 11, 2007 @ 17:31:30  

I have a connection to SqlServer db. I can read data into table fine. I have added sql to addupdatesql method and that sql seems to work (i.e. i tried it independantly in an SQL editor and I get no errors from DBTable when it executes. The displayed data changes but the changes are not propagated back to the database. I have autocomit on and have tried to manually commit data by adding a databaseChangeListener but nothing works. (btw delete doesn't work either)

1) How can I look at the exact sql string that is being executed during the update?
2) What am I missing in order to do updates?

Admin
Board Owner

Gender: Unspecified
Location:
Registered: Jul 2003
Status: Offline
Posts: 9

Click here to see the profile for Admin Send email to Admin Send private message to Admin Find more posts by Admin Edit or delete this message Reply w/Quote
Posted Tuesday, September 11, 2007 @ 22:19:21  

set dbTable.debug=true and all debug messages including sql will be printed to stdout
jamen
Corporal

Gender: Unspecified
Location:
Registered: Sep 2007
Status: Offline
Posts: 22

Click here to see the profile for jamen Send email to jamen Send private message to jamen Find more posts by jamen Edit or delete this message Reply w/Quote
Posted Wednesday, September 12, 2007 @ 10:17:07  

Ok that helped.

Problem was that the column numbers seem to be '1' based not '0' based like the rest of java. When I adjusted the column numbering all worked fine.

Post New Topic   Post A Reply Jump to:
Contact Us | QuickTable - A Java DBGrid | Privacy Policy All times are GMT -5 Hours.
Welcome to QuickTable Forums, Guest!  
Login
Username :
Password :
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!
Powered by CuteCast v2.0 BETA 2
Copyright © 2001-2003 ArtsCore Studios