Board index Database Programming

VB 3.0 and VBSQL.VBX

VB 3.0 and VBSQL.VBX

Post by Brian Baue » Wed, 17 Jul 1996 04:00:00



I recently installed Windows 95 and VB 4.0 on my desktop system.  I now
have both VB 3.0 and VB 4.0 on the same system.  All of my past projects
were developed under VB 3.0 and use DB-Library. I now run into a problem
when I add the vbsql.vbx to any new project in VB 3.0.  The error message
says "can't load custom control 'VBSQL.VBX'"  If anyone can lend some
advice on this one, I would appreciate it.  I don't know if there is a new
vbsql I should be using or if Win95 is causing the problem

Thanks
Brian Bauer

 
 
 
Top

VB 3.0 and VBSQL.VBX

Post by Umesh Murth » Thu, 18 Jul 1996 04:00:00



> I recently installed Windows 95 and VB 4.0 on my desktop system.  I now
> have both VB 3.0 and VB 4.0 on the same system.  All of my past projects
> Brian Bauer

Which version of VB4.0 are you using?16-bit or 32-bit.  With the 32-bit
edition, you cannot load a .VBX, you will have to get the .OCX.
regards
Umesh

 
 
 
Top

1. VBSQL.VBX -> VBSQL.OCX

We're moving a five-year old program that uses the VBSQL function
library from VB3 to VB5.  We already had the 32-bit VBSQL control and
the change over seemed easy.  The only real change involved was making
the integers into longs.  Here's the problem:

Everything seems to work except for one particular SQL statement.

"update customer.dbo.order_num_unique set flag=1 where order_node = 9
and flag=0"

The problem occurs when calling SQLCount after looping through
SQLResults and SQLNextRow.  It returns 0 even though the command works
and the table is updated.  We should get a 1.
1)  This code works in VB3.
2)  the SQLCount returns a 1 if "flag = 0" is removed from the
statement.  Unfortunately, we need to keep that in.
3)  The entire statement works if run just after logging on the the
server.

We'd prefer not to switch to RDO because we've got so much time invested
based on VBSQL.  If you think the change over would be worth it, please
let us know.
Thanks for any ideas.

Andrew Harrington
Wall Street On Demand

2. Opinion on free tool?

3. replay vbsql.vbx with vbsql.ocx

4. Help: Index Question

5. VB->VBSQL.VBX->MS SQL Problem

6. Multiple Entries in a Field

7. VB 3.0 database .vbx wanted.

8. Does VBSQL.VBX come with SQL Server?

9. Where do I find VBSQL.VBX?

10. Problems adding VBSQL.VBX to project.

11. Anyone using DB-LIB(vbsql.vbx)?


All times are UTC
Board index