Thread: New to VB with a basic database question

I'm glad you've got it sorted. Quote: My code is messy. Its tough to read and I should really comment my code way more. The amount of comments is not an issue, but the things you have commented are less than ideal. For example, the " Set rs1 " line does not need a comment (it is almost as quick to read+understand the line of code rather than the comment), and even more so for lines like .AddNew and .Update What you...

Post sample of generated trigger

SQL Server CE is not the right choice here. It's generally not intended for multi-user systems. SQL Server Express would probably do the job. Like I said, it has some limitations, e.g. 4 GB max size for databases, but if you don't have an issue with them then it's probably easier to administer than MySQL. MySQL will certainly do the job though, and would be a better choice if SQL Server Express' limitations are an issue.

Quote: Originally Posted by leinad31 That is only ONE aspect/purpose of pooling; due to request-response (web) environment where opening and closing connections will take too much time otherwise. Also, a single username in a client-server environment (just to justify use of pooling) means deployment of credentials with app; not my cup of tea. That's the point of pooling... the connection isn't actually closed on the server... it...

Perhaps EXISTS?

Quote: Originally Posted by stateofidleness awesome, looks like that one is working just fine! struggling with the second one on this part: Code: IsNull(COUNT(Student.Faculty_ID),0) Says invalid number of arguments. I deleted the 0 part and the query runs, but it creates a weird field name at the end populated with 0's. And there should only be 3 records in the resulting table, this shows 7.. so it seems like I need the opposite. For the...

You are passing 'camion' into the @TipAutomobil parameter and comparing that to tab3.IdTip. The error occurs there. What is the datatype of tab3.IdTip?

http://www.vbforums.com/showthread.php?t=337051#ado

i mean the dates...can you not pass them as variable parameters ...i am sure there is a way without having to hard code them....i must say thanks for the construct works pretty well...i have tried it but now i just need it work with variables

Quote: Originally Posted by jmcilhinney VB6 or VB.NET? Which database? s i'm sorry... the language is VB6 and the database are access. but i need also an example for Sql Server Tks.