Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fruityBoy

    sqlexec + sql server inconsistent results

    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
  2. fruityBoy

    sqlexec + sql server inconsistent results

    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
  3. fruityBoy

    sqlexec + sql server inconsistent results

    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...
  4. fruityBoy

    Inserting a field . . . but how

    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
  5. fruityBoy

    Program is haunted. Refrers to values no longer there

    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...
  6. fruityBoy

    Program is haunted. Refrers to values no longer there

    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...
  7. fruityBoy

    form.release() question

    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()
  8. fruityBoy

    Freeze panes in standard grid control

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

    Freeze panes in standard grid control

    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...
  10. fruityBoy

    string parising - problem with the commas

    ...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 lcvalue=...
  11. fruityBoy

    Freeze panes in standard grid control

    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...
  12. fruityBoy

    sql or not

    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...
  13. fruityBoy

    Can u reference an object by a relative reference?

    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'...
  14. fruityBoy

    How can I Partition a VFP Database Table into Sections?

    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...
  15. fruityBoy

    Microsoft TechNet subscription

    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...
  16. fruityBoy

    Deleted file removed from user permissions

    Hi I have a client running Novell 4.11, which is running my software. Now, one of the users has a very low access level, and is therefore only given (read only) access to a certain file in the data directory of my program, in order to run a report. However, as part of the month-end...
  17. fruityBoy

    Too many variables -> oledb with ADO

    Hey Guys,I'm hoping that somebody else has come across this. I'm using ADO 2.6 to write/read into / out of a Visual 7 database from Visual Fox 7. However, on occasions, I receive the messsage : "oledb provider for microsoft visual foxpro : too many variables". Now, all I am doing is...
  18. fruityBoy

    DDEInitiate and Excel

    Hi cheers for your help! This is so long ago I'd forgotton about it. What I ended up doing is what you suggested really, I stored the path to excel in the .ini file of my app, so I could find it there. The spreadsheet was only going to be run on one computer, so I could afford to hardcode...
  19. fruityBoy

    Deleted Records in Buffers

    That follows, yeah, thanks for your help, I'll write an insert trigger and see if it works (I'll post to this thread and let you know if it does). Thanks Again Simon
  20. fruityBoy

    Deleted Records in Buffers

    Hi Yeah, the system demands that deleted records in the buffer are inserted into the database so that the user's actions in all circumstances can be traced (i.e., we want to know if he / she is inserting lots of records and then deleting them before a table update). The information can be...

Part and Inventory Search

Back
Top