4 replies to this topic

[ORACLE]

Access database query using sql help !!!
I am using vb 6.
I get a message saying query too complex, i have loads of check boxes acting as cinema seats, that are booked and not booked.
Im current using this:

Adodc1.Recordset.Update

Adodc1.Recordset.Requery

Can anyone tell me how to maybe save it in a different way???
maybe like this??

Adodc1.Recordset.Fields("r1-1") = Check1

Adodc1.Recordset.Fields("r1-2") = Check2

Adodc1.Recordset.Fields("r1-3") = Check3

Adodc1.Recordset.Fields("r1-4") = Check4

Adodc1.Recordset.Fields("r1-5") = Check5

thanks for any help, i need this very soon, sorry about the rush.
thanks

[Lop]

Is it possible for you to show us the query?

[ORACLE]

I am trying to save the follwing data types (check boxes) to my database as shown it these images:
Example here in Vb

This is it running:
Example running

My database name is: cinema

My table is: booking

And my table is layed out as show bellow:
Click here
It go's "r1-1" up to "r1-20"
It go's "r2-1" up to "r2-20"
It go's "r3-1" up to "r3-20"
It go's "r4-1" up to "r4-20"
It go's "r5-1" up to "r5-20"
It go's "r6-1" up to "r6-20"

hope this makes it clear now
thanks in advanced
ORACLE

Attached Files

•  example access.JPG   100.13K   2571 downloads
•  example running.JPG   88.62K   745 downloads
•  example.JPG   118.33K   759 downloads

[ORACLE]

should i busing ADO