Search results for query: *

Olaf, Many thanks for your direction in this, my issue is resolved with success! I turned out fairly simple in the end, all I had to do was edit the SQL behind the VFP Remote View of the MySQL table, don't need to use SPT direct at all. For the VARCHAR field I edited the following, note the...

Olaf, Thanks for you earlier reply. I am still struggling for a solution. I know that using ODBC as such isn't the problem, as all works fine in an Access view of the remote data. I know the remote data is utf-8, but I don't know what my Windows 7 PC is ... I have tried using all 16 values of...

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

SOLVED! Thanks, I wasn't aware of the EVALUATE() function, that works perfectly and means I can drop a long CASE statement I was using to provide for all possibilities. Not needing the ALLT(STR()) with PADL() is also a new one for me ... isn't it great to learn things! I did make some errors...

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

Thanks people for the pointers! It seems to me that SQL in some form is the way to proceed ...

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

Thanks to all for suggestions. The forms init event has a call as follows: thisform.cmbCompany.SetFocus When I comment out this all works fine. If I leave it there but comment out all code on the combo box the problem stays. The combo box is the one supplied with VFP. Anyway, I have a...

LockScreen = .f., thanks for the suggestion. I have gone through every property setting doing a comparision with a form that does behave as expected and can't see the issue.

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

Thanks for the idea Doug, but what does this do? I tried clicking on the body section of reading an email and writing an email and rolling the mouse wheel up/down. It moves the Windows up/down but has no impact on font size. Am I missing something?

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

>digitalquatro (Programmer) 17 Jan 06 19:54 >Go to Tools->Options and select the File Locations Tab and >remove the content of Report Builder...It works for me... >Hope it helps! Thanks Mike, the above solved the problem for me ...

Hi Mike, Even if I create a new report in a new project I cant add/edit an expression.

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 ?