Forum: Visual Basic 4 / 5 / 6  Mar 27th, 2006 |
| Replies: 5 Views: 4,682 I'm sorry but I didn't know that ToLower() is a VB.NET specific function. You see, I've never programmed in VB4/5/6 before, but I had done VB.NET and VBA so I thought I might be able to share... |
| Forum: Visual Basic 4 / 5 / 6 Mar 27th, 2006 |
| Replies: 5 Views: 4,682 I believe Access does not have the LIMIT keyword, and that is only an extension specific to MySQL. MS SQL Server uses TOP but I don't think Access has this function. Also, Access and MS SQL Server... |
| Forum: Visual Basic 4 / 5 / 6 Mar 27th, 2006 |
| Replies: 15 Views: 5,361 Just rating this thread. Wasn't able to edit my previous posts to do this. Apparently there is a 30 minutes edit limit. |
| Forum: Visual Basic 4 / 5 / 6 Mar 27th, 2006 |
| Replies: 2 Views: 1,461 You need to buy VB in the sense that you need to buy the IDE/compiler, because VB is Microsoft propietry. But I believe Microsoft provides a free version of the IDE/compiler; I do not know about VB... |
| Forum: Visual Basic 4 / 5 / 6 Mar 27th, 2006 |
| Replies: 15 Views: 5,361 Sure. I'd be looking forward to that when I have the time to write a full tutorial out.
I just recalled this regarding the use of \' in an SQL statement. I would not recommend that, one reason is... |
| Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2006 |
| Replies: 15 Views: 5,361 I concur with what you've said. I would imagine that he tested this out in Access at the Query panel, where it is known for creating SQL statements that sometimes work internally only. Been there,... |
| Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2006 |
| Replies: 15 Views: 5,361 It's hard to say because of the kind of data put into the database at a certain insertion.
I do not know if you have heard of this term "MVC", but it you have, I would like to first of all say... |
| Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2006 |
| Replies: 15 Views: 5,361 Comatose, I'm sorry but I believe you got me wrong. I said:
I did not mean anything about escaping double quotes in VB. I know that I have to use Chr(34) to use the double quote... painful yes,... |
| Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2006 |
| Replies: 15 Views: 5,361 I agree with the frequency of this mistake. Normally what I would do in Java if I'm not using a PreparedStatement is something to this extent:
String sql = "INSERT INTO [MyTable] ([VChar1], [Dbl2],... |
| Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2006 |
| Replies: 15 Views: 5,361 Oh yes, you might want to post this in the database forum next time... I think this is more of a database question than a VB question. I would not have spotted it if I didn't happen to venture into... |
| Forum: Visual Basic 4 / 5 / 6 Mar 26th, 2006 |
| Replies: 15 Views: 5,361 Dear Sul, I do not know if you know about Queries in Microsoft Access.
Queries in Microsoft Access are more commonly known as "Views" in the database world. They behave exactly like Tables but... |
