Recent content by fruityBoy

I've successfully trapped the ODBC error,the only information I get is : Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources I'm going to use SQL Server tracing to see if I can track any more information. Simon

Hi Mike Thanks for your info! I didn't know that aerror returned ODBC error information even though it's not a trapped Foxpro error (ie 1526). I'll build some diagnostics with this and see what I get back. Thanks for your help Simon

Hi I've got a VFP7 front end which talks to Microsoft SQL Server 2005. I use sqlexec to pass queries to the database in order to produce report information. Most of the time, this is fine, however, on occassion, sqlexec will return -1, and the results cursor is not created. If I run the...

Hi , assuming you are upating table 1 and 2 independantly, and the code field is unique in both tables... select table1.*, table2.todayqty inner join on table2.code ==table1.code into table table3

Well, a quick test: 1. Run the software on another computer: if you don't get the error: it does indeed suggest that you have the devil in your computer otherwise: the devil could be resident in the building (i'd get out of there) Seriously tho, it does sound like remote data source...

You say that you are using the Access driver, can I assume that the database is an Access one you are using, not fox? If so, you may have changed the data in Access, but if you are using views in Fox, the view may still contain the old field name, not the new one, and therefore will present...

Hi you could pass the form as an object reference eg: do form2 with this in the init of form2 lparam ; localler this.caller_o = localler in the release: local ; localler localler = this.caller_o localler.savemode()

Hey! This looks like the stuff I have been looking for! I'll let you know how I get on - thanks very much!

rgbean, I think that you are actually splitting the panes, like the grid control does, by using the split bar at the top right of the sheet? If you move to cell A18, and choose 'freeze panes' from the window menu, then you will see what I mean!! I know that the grid control is not a spread...

Hi, this is the method I use for parsing delimited strings FOR lnindex = 1 TO LEN(lcpercs) lcchar = SUBSTR(lcpercs,lnindex,1) IF lcchar == LCDELIM ** this is our value DIMENSION lapercs[lncount] lapercs[lncount] = VAL(lcvalue) lcvalue = '' lncount = lncount +1 ELSE...

Hi I'm trying to replicate the 'freeze panes' feature available on Microsoft Excel for a standard foxpro grid control. Unfortunately, the only way I can see to do this is to use the 'split', or 'partition' properties. Now, the problem with this solution is that all of the columns are still...

Another (slightly different) method that I've used in the past is DCOM objects using Microsoft Transaction Server. Basically, using ADO as the transport mechanism, you can call remote foxpro DCOM objects to process and return data, and, the good thing is that the DCOM objects, because they are...

Why not set a property, or a regional / public variable to the object, e.g. public bob bob = thisform.pageframe1.textbox1 (for example) then to set values from anywhere in the program, if bob is public,or you could have a system object where bob is property , you could do: bob.value = 'hi'...

What I think I would do, is create three 'views' (which are just editable queries) each view would filter for the specific type, therefore you would have a beams view, a frames view and an accessories view which would appear as 3 different tables in the database, and they are updatable to boot...

Hi mate, if all you do, purely, is program Foxpro, then I don't think that you need technet to be honest. It's really in-depth information about Microsoft products, every thing you really need to know from a system guy's point of view. It could be useful say, if fox was behaving oddly in...