Recent content by manojab

does the final price show up on the form.. after you run the first query.. if yes then run the second pass the field from the final price on the form as a paramter that should work i think

Have status field in that table call Sold Status & set it as a bit field everytime an ordered is placed & a turkey is sold... run the update query which would say somethin like this UPDATE tblNAME SET soldStatus = 1 where Id = "get the ID from the Order Form" And when you retrieve data from...

Here's what i found out....if you change the compatability options under SQL 2000 to SQL Server70 instead of 80 then it works fine.... to get there right click on a data base, then properties, then options & under that u will see a drop down called Compatability Level hope this helps if anyone...

Your strSQL_String is empty..enter some select, insert,update or delete statement..then try it.. it should work

Your strSQL_String is empty..enter some select, insert,update or delete statement..then try it.. it should work

thanx Epic There is no bit field with Null Value.. & also i have the default value saved as 0

Update tblTest set process = 0 where process = 1 or if try Update tblTest set process = 0 where process = -1 both of these queries fail the SQL datatype is a bit thanx M

also my data type in SQL2000 is a bit

Yea it works when i use true or false in the query but in all my applications I use 1 and 0 or -1 and 0 for true or false. coz SQL7.0 translates the boolean just fine... but SQL 2000 fails to do the translation So if i start using true or false.. i will have to change all the update queries in...

I'm sure u set a flag somewhere in the table which tells u if a vehicle was serviced or not..so for ur report just call all the vehicles that have a not serviced flag & those vehicles will have the next service date on them!! hope it makes sense!!!

Bit Fields are true (-1) in Access but in SQL server i think its 1..but even if it is -1 it still does not work?.. the data translation from Acess to SQL 2000 is not happening!! thanx M

Solution!!! Hi Doc Man, I found the soultion to my problem in this Microsoft Knowledge Base article http://support.microsoft.com/default.aspx?scid=kb;en-us;210111 thanx guys Manoj

Hi Guys, I need some help to understand this... I have an application in Access 2000(front end) & I use linked tables from SQL 2000(Back end). I have a table test.. I'm tryin to update a bit field from 0 to 1 using an update query. It does not perform the update. "Update tblTest set process =...

Appreciate ur help Doc!!!

Pat Thanx Doc, I'm new here..dunno who Pat is..can u give me his user name so that i can probably email him??