Search results for query: *

I have a problem using an ODBC connection & a VFP remote view to insert records into a table. If I update a field (VARCHAR(100)) using the SQLyog utility I can write a value, e.g. "fixed text", and it is stored fine. If I use my Remote View to make the same change it appears ok when viewed in...

Ref: thread1252-1087450 I have multiple users accessing an Access.MDB via remote view in my Foxpro.DBC - work great, except I keep having to explain how to create ODBC connections to users :-( Is it possible to check if a connect exists on a workstation, if not create it (knowing where the...

Can anyone say if the following REPLACE statement is valid? FOR lnCycle = 1 TO gnTotalPeriods lcField = ReportData.Period_"+PADL(ALLTRIM(STR(lnCycle)),2,"0") lcGetBudgField = "nbudg.nb_cbp"+PADL(ALLTRIM(STR(lnCycle)),2,"0") * REPLACE (lcField) WITH (&lcBudgField) && Error "Missing...

I've been told that using "Windows file shares" to run an application/database access is bad from a security viewpoint. Can anyone say what the weakness is or what the alternative is? The application is a native Visual Foxpro application with its own database (non-SQL), so users need full r/w...

Hi all, I have a top level form with a WindowState = 2, I want it to fill the Windows screen, whatever its resolution/size. The formname.load contains contains: Messagebox(this.WindowState), giving a value of 2 (max) The formname.init contains the same: Messagebox(this.WindowState), but...

With GM 6.5 (dBase version) the email client seems to default to Tahoma 8 point font. Not having great eye sight this means I awlays need to edit thje font to make it 11 point ... Does anyone know how to set a default font size ? Ta!

I can't seem to detect when Ctrl+Right Arrow keyboard combination is pressed. In the following nKeyCode & nShiftAltCtrl are the same whether you press Crtl+RightArrow or Ctrl+F ? Also, in the VFP9 Help I notice that INKEY() has a Ctrl value of "2" for both Ctrl+B key press and Ctrl+RightArrow...

Can anyone clarify what the siotuation is regarding use of old MS-DOS and 16 bit Windows applications with the different versions of Vista that appear to be available?

Can anyone advise on how to convert this to VFP syntax Range("P5").AddComment Range("P5").Comment.Visible = False Range("P5").Comment.Text Text:=" :" & Chr(10) & "This is a comment" That is what an Excel macro produces in EXCEL to add comment text to a cell. In VFP using the above...

I am using automation to create Excel reports, if I create such an file from within my app and then try to launch Excel outside of automation (from my Desktop) I get an MS Error that MS wants me to submit etc. Then if I close my Excel session created above I notice that Task Manager still has...

When I attempt to modify or create an expression in any report, in any project, I get the following: Variable VPOS is not found line 0 in loadformfrx() fieldexprhandler.error() Any ideas anyone ?

Here is a routine I have to attempt to "FREEZE" (only allow editing) in fields numbered 3 to highest field number in a table I want to BROWSE. As the number of fields is changeable I tried substuting as below for the "FREEZE" statement, but it doesn't work ? Is there a way around this that...

How can I check if a particular table has a field of a specific name ? If I find it doesn't exist I need to create it using ALTER TABLE Many thanks, Diarmaid

Can anyone help with using GM6S32.DLL, I only have the manual for version GM5.7. What I like is to get the latest API Specifications & Sample PDF file and if anyone can offer advice on its use, sample code etc. Has anyone used GM6S32.DLL with Visual Foxpro ? Thanks in advance.

I hope this isn't the wrong forum for my question. Can anyone report any experience or opinion regarding "Visual Extend", the application development framework recently reviewed in Foxpro Advisor ? Many thanks, Diarmaid

I have a VFP8 .EXE file that I want to give to other users that don't have VFP8 installed, so they need the runtime files. Can anyone tell me what files I need to give in order to let other PC's/users use the .EXE with runtime. With VFP7 I used to distribute: VFP7R.DLL VFP7RENU.DLL...

Hi all, Is there a way to discover what workarea number is being used by a particular alias ? I need to do this as I need to set a pointer in a table with an app I didn't create. Many thanks for any help, Diarmaid

I would like to either add a new table to hold transactions linked to the main Contact1 table OR modify the structure of the Conthist table to add new fields that can subsequently used in reporting, viewing on screen within GM etc. Can anyone advise on this or point me to a source for further...

Can anyone tell me if GM SQL version is supported on Windows 2003 server ?

I am trying to source a company / individual who offers training on Visual Foxpro application development, it's environment etc. I have some experience with apps. in VFP, already understand procedural coding etc.