I have a VB6 program using a sybase database. I use ADO 2.6 to access the database. When I use the IsNull() on a field from that database (and the field is equal to null) I get an error "-2147024882 (8007000e) Not enough storage to complete this operation". It seems to ignore the fact that...
I think I'm missing something....
I have been coding in VB6 for a couple of years, last year I started using Sybase ASA 7 for my database and I'm becoming very frustrated (no training).
The latest thing has been removing data from fields - specifically date fields. With character fields I...
I have a VB6 program where I am loading data to the screen and I have
If IsNull(fieldname) then
do one thing
else
load data to screen fields
end if
When the code runs it bypasses the IsNull and tries to load the data to the screen. At that point I get the error:
-2147024882(8007000e)...
I am using VB6 with a sybase database. When I open a table using an SQL statement containing a "Where" clause I seem to lose the End-Of-File marker.
I can use MOVEFIRST, MOVENEXT, and MOVEPREVIOUS (if I haven't reached the end of file), but I cannot use MOVELAST (I get a BOF,EOF...
I use VB6.0 to connect to a Sybase database. I have some sql that works with an Access Database, but will not work with the Sybase.
The sql looks like this:
SELECT HeaderTable.SwisCode, DetailTable.ParcelNumber, Sum(IIf(HeaderTable.SchoolOrVillage =...
I am using the sstab1 control and need to be able to add and remove tabs at run time, but I can't seem to put any controls on the newly created tabs.
I select the tab I want:
sstab1.tab = x 'x = the number of the newly created tab
Then I load the control array that I want:
Load...
I am having a problem with my data grid. I have an event BeforeUpdate() for my dbgrid. If I test the program within VB everything runs fine. But, if I compile the program and run it and update any information in the dbgrid I get this error:
This Program has performed an illegal operation and...
I have a report that I put to a picture box for viewing. It can be larger than the printer object. When it is larger (let's say it's about twice the width and twice the height of the printer object), I want to split it into 4 chunks to print. I can get the top / left quad to print, but I...
I have a little VB6 program that does quick client lookups. I would like to be able to lookup a client in the VB program (which asks for a user signon and password) then click a button to start the existing Access program and pass the user signon, password and client ID to it. is this...
I use an Access '97 database and a datacontrol (dao 3.6). I can browse through the file using the datacontrols arrows to move next. I reach a certain record and the datacontrol will not move to the next record. There is no error. What could be wrong and how do I fix it?
I use the KILLDOC method in my project. When I send the print out to our IBM printer it works beautifully. When I send the print out to our HP printer, KILLDOC releases the document to print and does not kill it. Is there an issue with HP Printers?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.