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
update statements printer friendly version
next newest post | next oldest post
Author Messages
dleffler{@}payless.com
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

while trying to issue an update I am getting a strange error. I have used this for display only in the past and now I want to update from the table. I am doing the following commands....


getDBTable1().setSelectSql("Select ID, Name, Team, ffPts, HighBid from PlayerList where position = 'Quarterback'");
getDBTable1().addUpdateSql("update PlayerList set HighBid =? where ID =?","5,1");
getDBTable1().refresh();

getDBTable1().getColumn(0).setReadOnly(false);
getDBTable1().getColumn(1).setReadOnly(false);
getDBTable1().getColumn(2).setReadOnly(false);
getDBTable1().getColumn(3).setReadOnly(false);
getDBTable1().getColumn(4).setReadOnly(false);
.
.
.
Double highbid = ....

try {

admin{@}quicktable.org
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

If you can send me the java source file, a smaller version(with required tables & less data) of your mdb file and on doing what you are getting this error, I can try to solve your problem

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