VFP & Firebird SQL

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - .fxp is not an object file SOme strange reason, today I get this when trying to RUN / DEBUG a small pgm. I did not see any help from microsoft's KB articles. Suggestions? Thanks. Steve Tag: VFP & Firebird SQL Tag: 215142
  - 2
    - VFP9 KillFocus Hello everyone ! How can I kill the CommandButton's focus except for calling other control's SetFocus event when MouseLeave Event occured after I clicked the CommandButton in VFP9? Thanks a lot! Holy Tag: VFP & Firebird SQL Tag: 215134
  - 3
    - declare DLL call caused an exception Halo..Im using the vfp6.0 SP5+ VPMe6 to compile a setup ...its successfull install in the PC windows server 2003 SP1 but when running the program exe its prompt error "declare DLL call caused an exception".. Anyone can help me..please advice..thanks a lot regard, orange Tag: VFP & Firebird SQL Tag: 215131
  - 4
    - Checkbox in grid Hi I would like to use a checkbox in a column of a grid but I am not sure how to do this and also what type of field would the checkbox require. Help appreciated, warrenjw warrenjw@internode.on.net Tag: VFP & Firebird SQL Tag: 215129
  - 5
    - Add Method Problem I am having something wierd going on in VFP 9. I have a formset and go to form -> new method to create a method. I type in the name "testMethod" and hit add. This then adds the method to the currently active form in my formset, and not to the formset. I can go into the form.testMethod and add code to it. When I save and close out of the formset and then go back in, the method does not show up under the form nor does it show up under the formset. My workaround is to go to edit property method in the menu and then do add method there. Then everything works fine. Is anybody else having this same issue? P.S. I know formsets are not the best way to do things but I am working with old code and it would be alot of work to get them out of formsets. -- TIA Altman VFP9 Tag: VFP & Firebird SQL Tag: 215124
  - 6
    - Landscape reports Hi. In one of my applications I have a couple of Landscape reports. I send these reports to the windows spooler. Sending characters strings and using SET PRINT FONT. To do this, I test PRTINFO(1) = 0. If true,= SYS(1037) to allow the user to switch the landscape mode. Couple of problems with this technique. One, the user might not switch to landscape. Two, that print device stays in landscape mode until he switches back or exits FoxPro. Question. Is there a way my code could switch the print device back and forth from landscape mode? Without the need of SYS(1037). Any advice would be appreciated...Dennis Tag: VFP & Firebird SQL Tag: 215119
  - 7
    - VFP7 view with uncommitted changes - weird behaviour I have a situation, reproducable very occasionally but not consistently, where a requery after tableupdate fails with uncommited changes. I've looked at the view cursor in Debug and it looks really strange. This is the scenario (code that creates the view is below). The view is of a child table and has a filter in place equal to the id of the parent table. The view is in item number order. Add 5 records (items 1 to 5) to the view, delete the 3rd one (causes item 4 and 5 to resequence to item 3 and 4) and then save. Save scans the file (with set deleted off) and issues a tableupdate on each record. The subsequent requery sometimes fails. Browsing the cursor shows why it has failed but I can't see a reason for the cursor being in the state it is in! Debug says these are 8 records. Browsing displays 5. 2 records belonging to the previous header even though there is a filter in place so I don't know why these are showing. The 2nd item of the added items does not display. After setting the filter off and setting deleted off, 6 records display, the same 5 as above plus the deleted one. I then set the order off and 8 records then appeared. The 8th record was full of zeroes and characters that look like a thick letter I in some of the fields. Where this came from I have no idea. I have no idea where to go from this point as it seems to be VFP7 doing something outwith my control. Has anyone had this kind of problem before? Thanks for any help. Bernie Beattie Here is the code that creates the view: CREATE SQL VIEW V_NLJDTL AS ; SELECT NLJDTL.nljdtl_id AS nljdtl_id,; NLJDTL.nljhead_id AS nljhead_id,; NLJDTL.item_no AS item_no,; NLJDTL.acctno AS acctno,; NLJDTL.db_or_cr AS db_or_cr,; NLJDTL.tran_amt AS tran_amt,; IIF(nljdtl.db_or_cr='D',tran_amt,0000000000000.00) AS Debit,; IIF(nljdtl.db_or_cr='C',tran_amt,0000000000000.00) AS Credit,; NLJDTL.property AS property,; NLJDTL.REFERENCE AS REFERENCE,; NLJDTL.reconc_id AS reconc_id,; NLJDTL.added_dt AS added_dt,; NLJDTL.changed_dt AS changed_dt,; NLJDTL.vatst_pr AS vatst_pr, ; nljdtl.rcveble_id as rcveble_id,; nljdtl.plinv_id as plinv_id,; NLACCD.COMPULSPRP AS COMPULSPRP,; NLACCD.ACCTYPE_ID AS ACCTYPE_ID ; FROM NLJDTL,NLACCD ; WHERE NLJDTL.acctno=NLACCD.acctno AND NLJDTL.acctno<>0 AND nljdtl.nljhead_id=?pnhead_id *make the view updatable DBSETPROP('v_nljdtl','View','Tables','nljdtl') DBSETPROP('v_nljdtl.nljdtl_id','Field','KeyField',.T.) DBSETPROP('v_nljdtl.nljdtl_id','Field','UpdateName','nljdtl.nljdtl_id') DBSETPROP('v_nljdtl.nljhead_id','Field','UpdateName','nljdtl.nljhead_id') DBSETPROP('v_nljdtl.item_no','Field','UpdateName','nljdtl.item_no') DBSETPROP('v_nljdtl.acctno','Field','UpdateName','nljdtl.acctno') DBSETPROP('v_nljdtl.db_or_cr','Field','UpdateName','nljdtl.db_or_cr') DBSETPROP('v_nljdtl.tran_amt','Field','UpdateName','nljdtl.tran_amt') DBSETPROP('v_nljdtl.property','Field','UpdateName','nljdtl.property') DBSETPROP('v_nljdtl.reference','Field','UpdateName','nljdtl.reference') DBSETPROP('v_nljdtl.reconc_id','Field','UpdateName','nljdtl.reconc_id') DBSETPROP('v_nljdtl.added_dt','Field','UpdateName','nljdtl.added_dt') DBSETPROP('v_nljdtl.changed_dt','Field','UpdateName','nljdtl.changed_dt') DBSETPROP('v_nljdtl.vatst_pr','Field','UpdateName','nljdtl.vatst_pr') DBSETPROP('v_nljdtl.nljdtl_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.nljhead_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.item_no','Field','Updatable',.T.) DBSETPROP('v_nljdtl.acctno','Field','Updatable',.T.) DBSETPROP('v_nljdtl.db_or_cr','Field','Updatable',.T.) DBSETPROP('v_nljdtl.tran_amt','Field','Updatable',.T.) DBSETPROP('v_nljdtl.property','Field','Updatable',.T.) DBSETPROP('v_nljdtl.reference','Field','Updatable',.T.) DBSETPROP('v_nljdtl.reconc_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.added_dt','Field','Updatable',.T.) DBSETPROP('v_nljdtl.changed_dt','Field','Updatable',.T.) DBSETPROP('v_nljdtl.vatst_pr','Field','Updatable',.T.) DBSETPROP('v_nljdtl.rcveble_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.plinv_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl.compulsprp','Field','Updatable',.T.) DBSETPROP('v_nljdtl.acctype_id','Field','Updatable',.T.) DBSETPROP('v_nljdtl','View','SendUpdates',.T.) *open the view SELECT SELECT(1) USE V_NLJDTL EXCL INDEX ON STR(nljhead_id)+STR(item_no,3) TAG UNIQUE_KEY INDEX ON item_no TAG item_no INDEX ON acctno TAG acctno INDEX ON Debit TAG Debit INDEX ON Credit TAG Credit INDEX ON UPPER(property) TAG property INDEX ON UPPER(REFERENCE) TAG REFERENCE CURSORSETPROP("buffering",5) &&optimistic table buffering Tag: VFP & Firebird SQL Tag: 215118
  - 8
    - Multi-Lingual in VFP I've got to make a multi lingual application in VFP 9.0, exept the Steven Black INT'L component, does someone have a native and free soluton. Thanks. Patrick Tag: VFP & Firebird SQL Tag: 215115
  - 9
    - Bugg? in tableupdate - VFP8-SP1 I have problems with tableupdate. Tableupdate returns F even after success. It happens if the field below is of type memo and the corespondending .fpt file is quite large (10M). Small files - no problems. * write to table SET REPROCESS TO 3 SECONDS && 10 seconds is not better IF CURVAL(lcFieldName,lcAlias) == OLDVAL(lcFieldName,lcAlias) llUpdated = tableupdate(1,.F.,lcAlias) IF llUpdated = .T. wait 'Saved' nowait window ELSE && i.e. unother user has removed the record TABLEREVERT(.F.,lcAlias) MESSAGEBOX('Save failed, record removed by unother user', ; 0+48,'Securityinformation') ENDIF ENDIF The code above fires the messagebox. But if I continue to use the app I can see that the view´s sourcetable is updated after all. Hints about this should bee very appreciated. Best regards Christina Tag: VFP & Firebird SQL Tag: 215108
  - 10
    - Excel automation I'm getting an "Unknown COM status error" on the second line of code below (owb is an Excel Workbook object). This works fine in the development environment, but not on the end user deployment. I'm guessing that VFP being installed might help. Does anyone know what I need to install to make this work? Briefly, the code populates a worksheet, creates a graph from it, saves the graph as HTML and displays it in a browser. lcWeekChart = sys(5) + curdir() + "graphs\" + sys(2015) + ".htm" with owb.PublishObjects.Add(xlSourceChart, lcWeekChart, "Chart1", "", xlHtmlChart, "Weekly Sales", "") AFAIK, the development and production environments are using the same Office 2003 install. Thanks for any help, Neil Tag: VFP & Firebird SQL Tag: 215098
  - 11
    - Help Files I have made a chm help file called scgHelp.chm I have "set help on" Set help to scgHelp.chm It works great on my system XP Home, however my customers with XP Home, nothing happens, help doesn't work. Any Suggestions ? Loren Tag: VFP & Firebird SQL Tag: 215097
  - 12
    - seek I have tables with compound indexes. Performing a seek seems to require the padding of the fields (at least the first field of the index). The index in not based on the padding. Am I missing something? Do I need to pad the variables I am seeking? Tag: VFP & Firebird SQL Tag: 215076
  - 13
    - Image name with image oddity on forms and reports. I have an app done for somebody else where photos shown on form and report. I have never got this, myself but the client sometimes reports strange image titles included with the image. For example it would show or print the image and right underneath it it would print the name of the image file. -------- | | | | |(Image) | | | | | | | -------- Logo.bmp Anybody seen this and a solution? ----------------------------------------------------------------- Paul Lee ........... Abri Technologies ......... http://abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: VFP & Firebird SQL Tag: 215072
  - 14
    - VFP9 report anomalies with picture I'm adding a gif picture to a VFP9 report (REPORTBEHAVIOR = 80, non-GDI+). I don't know whether this matters, but it's a label printer, 1" x 3", landscape mode. 1. When I tap the arrow keys to move the picture, it shrinks instead of moving, as if it were moving only the left or top sides. 2. When I double-click the object to edit the properties manually, the path to the picture gets corrupted. For example, if the path is c:\folder\mypic.gif it gets changed to c:\folder\folder\mypic.gif Anyone else seen this, or is my computer going crazy? Tag: VFP & Firebird SQL Tag: 215069
  - 15
    - COPY TO FIELDS x,x,x TYPE SDF - Erratic Integer translations! Does anyone know what FoxPro is doing when it writes out SDF files and converts integer fields? I am attempting to copy out an SDF file for BULK INSERT into SQL. I need only a subset of fields, so I am using the FIELDS x,x,x parameter, and this seems to throw FoxPro's Integer column conversion into a bit of a tailspin. For example: CREATE CURSOR Mewp (char1 c(10), char2 c(10), int1 I, int2 I) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('asdf','qwer',1,2) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('zxcv','zxcv',3,4) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('tyui','ghjk',5,6) COPY TO C:\Temp\Temp1.txt TYPE SDF ^ the above reacts as it should, integer columns are 11 characters long, right justified. Now: CREATE CURSOR Mewp (int1 I, int2 I, char1 c(10), char2 c(10)) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('asdf','qwer',1,2) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('zxcv','zxcv',3,4) INSERT INTO mewp (char1, char2, int1, int2) VALUES ('tyui','ghjk',5,6) COPY TO c:\temp\temp2.txt FIELDS Int1, Int2, Char1, Char2 TYPE sdf ^ Field order in the source is different, but same field names and datatypes. In Temp2.txt, the integer columns are LEFT justified, and only 10 characters. In the table I first tested on and discovered the erratic behavior, I have a much wider field layout, a much wider integer range, and a much larger dataset, and in that instance, the integer column (first in the FIELDS list, last in the table structure) in the SDF file is 11 characters, right justified, followed by 10 spaces. In another large test I ran with a slightly smaller field layout and dataset, it was 11 characters right justified, followed by 4 spaces. I haven't been able to reproduce either of these outside of the tables i'm using, so I'm not sure if the field types, field names, integer values, table size, or what is causing the change in conversion. Anyone have any experience on this that might lend some insite? Tag: VFP & Firebird SQL Tag: 215068
  - 16
    - Citizen CBM1000 Type II receipt printer How to open the cash drawer model POSIFLEX CR4100 connect with Citizen CBM 1000 Type II receipt printer ? thank you. Tag: VFP & Firebird SQL Tag: 215061
  - 17
    - Localhost VFP7 application. Need to connect to web service, which is running locally on the same PC. I have some sample code (I think it's .net) that I need help converting to VFP for the objSdk and objError objects. Dim sHandle As String Dim objSdk As New localhost.SmpSdk Dim objError As New localhost.clsSdkError sHandle = objSdk.SdkZLogin (cUser,cPassword, objError) If (sHandle = "") MsgBox ("Invalid Login") Else MsgBox ("Login Success") End if TIA Tag: VFP & Firebird SQL Tag: 215054
  - 18
    - Get file from URL in VFP 5.0 Our application sends data to a third party's website who will manipulate it. I've got this part working just fine by opening an instance of IE and sending our data in the address. But now we need to retrieve the data back from their server. Any clues on how to get the file to our hard drive? We asked them to drop a cookie, but they don't want to go that route. Since I'm working in 5.0 I'm not sure what options are available. I might be able to convince them to display the data in the browser window if that makes a difference. Thanks very much in advance, Tag: VFP & Firebird SQL Tag: 215046
  - 19
    - Find I most often use the "All objects" on Find. Is there any way to make that the default instead of the current procedure? TIA Tag: VFP & Firebird SQL Tag: 215044
  - 20
    - frx2word I use for my reports frx2word. All reports works. But by some windows 2000 Computer with office 2000 it dosnt work.It comes no Error Messages. But the doc file is empty. Thanx -- Cengiz Zengin CZ Computer Tag: VFP & Firebird SQL Tag: 215034
  - 21
    - installshield The InstallShield of VFP 9 really `scared` me.. So much complicated than VFP6's setup wizard... -- .~. Might, Courage, Vision. http://www.linux-sxs.org / v \ /( _ )\ Linux 2.4.31 ^ ^ 8:48pm up 37 min 5 users 1.57 1.66 Tag: VFP & Firebird SQL Tag: 215029
  - 22
    - FPW2.6 check if report available programmatically I'm writing a program that uses a report. This program is usually compiled into .exes, and when building, the project manager finds the report and includes it in the .exe. However, this program is sometimes called from a standalone prg I run in the IDE. The report almost certainly won't be visible at run time and I don't want to make an identical copy elsewhere (although that would work.) What I would like to do is something like IF isexe() REPORT FORM report.frx TO PRINTER PROMPT ELSE REPORT FORM <full path to report>\report.frx ... ENDIF The best I've thought of is an ugly error trap: m.lno_frx=.F. ON ERROR m.lno_frx=.T. REPORT FORM report.frx TO PRINTER PROMPT ON ERROR IF m.lno_frx REPORT FORM <full path>.... ENDIF Any other ideas? -- TIA Andrew Howell Tag: VFP & Firebird SQL Tag: 215019
  - 23
    - How to update characte(binary) field on dbf table using cursoradap i create a dbf table that have some binary char fields and i want to use cusroradaptier via ADO to update. it cannot update when execute tableupdate() command. aerror() get the error as following error : 1435 Microsoft Cursor Engine : Multiple-step operation generated errors. Check each status value. it is same error either set mapbinary property on cursoradapter object to .t. or .f. sample code : ******************** IF !file("c:\test\test.dbf") CREATE TABLE c:\test\test.dbf (testval c(10) nocptrans) APPEND BLANK USE endif set multilocks on oca=createobject("cursoradapter") oca.alias="catest" oca.buffermodeoverride=5 oca.cursorschema="TESTVAL M" oca.datasourcetype="ADO" oca.keyfieldlist="TESTVAL" oca.mapbinary=.T. oca.selectcmd="Select * From test" oca.tables="test" oca.updatablefieldlist="TESTVAL" oca.updatenamelist="TESTVAL test.TESTVAL" loConnDataSource = createobject('ADODB.Connection') loConnDataSource.ConnectionString = [Provider=VFPOLEDB.1;Data Source=c:\test;Password="";Collating Sequence=MACHINE;] loConnDataSource.Open() oca.DataSource = createobject('ADODB.RecordSet') oca.DataSource.CursorLocation = 3 && adUseClient oca.DataSource.LockType = 3 && adLockOptimistic oca.DataSource.ActiveConnection = loConnDataSource oca.cursorfill() SELECT catest replace testval WITH "test" IF TABLEUPDATE(1) else =AERROR(amessage) =MESSAGEbox(amessage(2)) endif ******************** i'm using vfp9. -- Ray Tag: VFP & Firebird SQL Tag: 215018
  - 24
    - Third party tool required I need a third party tool to repair a corrupt dbf file. Thanx in advance Regards Nishu Tag: VFP & Firebird SQL Tag: 215012
  - 25
    - What does this mean ? I have come across a code snippet which I am unable to understand - the color statement - Can anybody help me understand this thing ? What does these so many RGB means in the deffinition ? MODIFY WINDOW lw_invoice NOGROW ; COLOR RGB(0,0,0,192,192,192), ; RGB(0,0,0,255,255,255),,,,,,,, ; RGB(0,0,0,192,192,192) ; FONT "Courier New", 9 Tag: VFP & Firebird SQL Tag: 215011
- Next
  - 1
    - How to make a user interface like Windows Explorer? Windows Explorer-style user interface is more kindly for user. how can I make it? TIA Song Tag: VFP & Firebird SQL Tag: 215009
  - 2
    - Replace question and table precision * make sure there are no DBCs open create cursor zoot (zz n(3,1)) append blank replace zz with 9.9 ? zz && prints 9.9 replace zz with 999 ? zz && prints 999 The last replace command should not work, but it does. Why? I've learned from experience that VFP is pretty sloppy about numeric fields if the table is not associated with a DBC, but I figured they would have fixed this by now? Is this left in for legacy purposes? Tag: VFP & Firebird SQL Tag: 215004
  - 3
    - [OT] User-Defined string Functions Transact-SQL <-> VFP Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions Transact-SQL: AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string. OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps). OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps). PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side. PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side. PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters. STRFILTER(): Removes all characters from a string except those specified. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a string. PROPER(): Returns from a character expression a string capitalized as appropriate for proper names. RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right search. ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999). ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX). AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. More than 4000 people have already downloaded my functions. I hope you will find them useful as well. For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 or http://nikiforov.developpez.com/ (the beautiful French language) Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards. Tag: VFP & Firebird SQL Tag: 215002
  - 4
    - VFP 6: clear events with Nonmodal Forms You might recall my question not too long ago about copy-cut-paste with toolbars. I am now looking at using nonmodal forms. I have a couple of problems. 1) Where do I put the clear events command? If I do not have it, my program does not terminate when all forms are closed. Since any form might be the last, what is the best placement? If I am using a menu, then presumably, I put it in the exit selection, but if I am not using a menu, what do I do? I suppose that I can have if _screen.formcount=0 && or 1, I am not sure clear events endif in a suitable event's (.unload()?) code, but it looks kludgy. 2) What is the best way to store the object references (so the forms stay in scope)? A global array? Do you have hardcoded references to array elements, search for a free element, or do something else? Sincerely, Gene Wirchenko Tag: VFP & Firebird SQL Tag: 215001
  - 5
    - VFP8 Intellisense issue I'm writing an ActiveX control (non-attributed ATL project in VS7). I've noticed a problem when testing this ActiveX control in Visual FoxPro 8 and 9. If I type "ThisForm.oleCtrl.", the trailing "." which triggers the intellisense code completion, causes vfp to shut down with a Buffer Overrun error message shown below. Anyone encountered this problem? Thanks, Greg ... Microsoft Visual C++ Runtime Library Buffer overrun detected! Program: ...ogram Files\Microsoft Visual FoxPro 8\vfp8.exe A buffer overrun has been detected which has corrupted the programs' internal state. The program cannot safely continue execution and must now be terminated. ... Tag: VFP & Firebird SQL Tag: 214997
  - 6
    - Connecting To DBF Using vfpoledb I have the need to connect to a remote DBF table across the network. Currently, I able to do this using a mapped drive which maps to the remote system where the DBF is stored, as such. Provider=vfpoledb;Data Source= \\remoteserver\dbffiles\; Mode=ReadWrite;Collating Sequence=MACHINE; However, mapped drives can be finicky. Now, the purpose of this post is to ask; "Is there a better way to do this, without the need for a mapped drive?" Tag: VFP & Firebird SQL Tag: 214982
  - 7
    - Printing on a dot matrix with vfp9 When I set report behavior 90, The fonts no longer print out correctly on a dot matrix printer. When I set report behavior 80 everything is fine. What Can I do to insure the fonts print out correctly? I tried saving the printer environment and it did not help. Sending output to generic text printer driver does not work well either. Tag: VFP & Firebird SQL Tag: 214979
  - 8
    - Migration from XBase++ to Visual FoxPro 9 Hi, I am working on a project in Visual FoxPro 9 which will eventually replace the existing software written in XBase++. During this migration process, I will use the existing XBase++ tables with cdx indexes. Does anyone have any recommendations or any data recommendations during this migration. I seem to have random index problems. The problem will not be there and then it shows up. I then delete the index file and reindex with the XBase++ software and the VFP9 software will still show the error. I then open the free table and the index in VFP9 and then issue reindex (This is done without trying to browse the table). All is cured. The table is still accessable from XBase++ software and VFP9 software. Anybody know what is going on here and what I need to start doing in order to make this work? Thank you, Mike Tag: VFP & Firebird SQL Tag: 214973
  - 9
    - PCL Codes Can you embed PCL printer codes to directly control the printer in a VFP report? Tag: VFP & Firebird SQL Tag: 214971
  - 10
    - Change colors of the Window Globaly ? I want all the windows in my application - which is already running and using different back ground colors - to have a specific color say blue - irrespective of the colors the windows are defined with - ? Is it possible either ? I am looking for a solution like a hook which keeps on looking whenever a user defined window becomes visible OR no matter is defined its back ground color changes to that specific color. Tag: VFP & Firebird SQL Tag: 214963
  - 11
    - CREATE OBJECT I develop application in vfp9 using the command CREATE OBJECT for link ole application and work fine with EXCEL, WORD and PP, but i cant do the same to link with WORDPAD or NOTEPAD, i will appreciate if could help to to fix these problem. Thanks. Tag: VFP & Firebird SQL Tag: 214962
  - 12
    - writing map software Not sure if this is the right place or not, but does anyone know how mapping software is written? i'd like to write a baby program to map out my building and where the different meeting rooms are located (time and distance to each room from a disgnated spot, etc). if anyone has any suggestions please send me an email. Tag: VFP & Firebird SQL Tag: 214960
  - 13
    - Keypress event F2 works in VFP6 but not VFP7 onwards I am converting an application from VFP6 to VFP9 and have discovered an issue that I hope someone can help with. I am trying to capture the F2 key being pressed within a textbox on a form in the keypress event (nKeyCode=-1). This would not work in VFP9 so after trying many things I built a basic form with one text control and a capture of the key press events to screen. It appears that in VFP6 the textbox keypress event happily tells me that F2 has been pressed, however in VFP7 onwards it appears that the F2 is not captured and nothing happens. The ON KEY LABEL is not active and F3, F4 etc are all working e.g. nKeyCode=-2, nKeyCode=-3 etc. This happens only with F2 (nKeyCode=-1). Does anyone know why? Is there something I am missing? This seems too simple an issue to be a bug? Thanks John R. Tag: VFP & Firebird SQL Tag: 214955
  - 14
    - DOS Filenames I am integrating an ActiveX control into my app. One of the properties is 'FileName'. Works fine till the property is set to a string containing the '~1' characters one gets from SYS(2023). Is there a utility/command that will convert the DOS path to a the real pathname? tnx, Howard Tag: VFP & Firebird SQL Tag: 214953
  - 15
    - Foxpro dll and Installshield I built a multithreaded com server (dll) in FoxPro 9 and put it into my installshield to install. When it tries to build the installer I get this message. The build was unable to extract COM information from the file <my dll file> in component <my dll file>. Please ensure that the file is self-registering and verify that the self-registration process does not fail. I can register it fine manually with regsvr32 but I do not want to manually register it. Is there any way around this or do I have to manually register this? -- TIA Altman VFP9 Tag: VFP & Firebird SQL Tag: 214948
  - 16
    - Predict Page Count When printing out a report, is there a way of counting the pages before you print them so that you can print something like Page 1 of 20. page 2 of 20 etc: on each page in the header? TonySper Tag: VFP & Firebird SQL Tag: 214945
  - 17
    - VFP6: open excel file and dump to .dbf Need to open a spreadsheet (Excel 2k) and dump contents to .dbf file using VFP6. Pretty generic really, sorry if this request isn't a challenge! Any sample type code would be appreciated. - Ben Tag: VFP & Firebird SQL Tag: 214942
  - 18
    - Rounding question and trig functions set decimals to 4 ? SIN(1)*COS(1) 0.45464871 ? .5*sin(2) 0.45465 VFP rounds the result, but why does the first get rounded to 8 digits, and the second get rounded to 5? SIN(1)*COS(1) is the same number as .5*sin(2), but VFP somehow treats the above calculations differently. If I put them in the watch window, they display the same as what is printed to _screen, with the same inconsistent rounding. Tag: VFP & Firebird SQL Tag: 214938
  - 19
    - sys(1500) This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5A28A.658070B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am just experimenting with this command. On a form with an editbox and = a commandbutton I have this code in the commandbutton click() _CLIPTEXT =3D "Hello world"=20 ThisForm.Edit1.SetFocus() SYS(1500, '_MED_PASTE', '_MEDIT') thisform.Refresh() The first time I click the button the edit cursor appears in the edit = box but nothing else. Thereafter every time I click the commandbutton, = the phrase appears as expected in the edit box, concatenating with the = previous paste.. Can somebody explain why it doesn't appear the first time? Many thanks Stephen ------=_NextPart_000_0006_01C5A28A.658070B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I am just experimenting with this = command. On a=20 form with an editbox and a commandbutton I have this code in the = commandbutton=20 click()</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>_CLIPTEXT =3D "Hello world"=20 <BR>ThisForm.Edit1.SetFocus()<BR>SYS(1500, '_MED_PASTE',=20 '_MEDIT')<BR>thisform.Refresh()</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The first time I click the button the = edit cursor=20 appears in the edit box but nothing else. Thereafter every time I click = the=20 commandbutton, the phrase appears as expected in the edit box, = concatenating=20 with the previous paste..</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Can somebody explain why it doesn't = appear the=20 first time?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C5A28A.658070B0-- Tag: VFP & Firebird SQL Tag: 214931
  - 20
    - Append data into excel file Dear All, Do anyone know how to append data into excel file from dbf file. Thanks for any reply or solution Choi Tag: VFP & Firebird SQL Tag: 214926
  - 21
    - MYSQL Database Has anyone converted a MySql database to a VFP table? I have a guy who has his database on MySql and would like me to enter it into a VFP Database table. I have not looked at it yet so do not know what to expect. Any ideas?? TonySper Tag: VFP & Firebird SQL Tag: 214922
  - 22
    - won't stay docked every time I open vfp8 I need to uncheck the dockable on all windows. How do I make it permanent? thanks sherry Tag: VFP & Firebird SQL Tag: 214918
  - 23
    - Using custom PAGE objects in a custome PAGEFRAME Hi I have been reading 1001 Things which seems to mainly reference VFP 6. I am trying to create a base _PAGE class for use in my base _PAGEFRAME class with some custom methods and properties. I can't work out how to trick my _PAGEFRAME to use my _PAGE class rather than the standard VFP Page object. In 1001 we are told that you cannot visually create a Page object - clearly this is no longer the case with VFP 9 so can anyone tell me how i can implement my visual _PAGE object? -- Kind regards Phil Hollingworth phil@wrltd.co.uk System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: VFP & Firebird SQL Tag: 214912
  - 24
    - Derfining a color Scheme ? How can I define a Color scheme at runtime based on the color scheme of certain control ? Want to have separate values for Red, Green and Black instead of using a single color value ? Tag: VFP & Firebird SQL Tag: 214908
  - 25
    - Custom window Color ? I want to set the color of a window which is to be determined at run time .. will be picked from the property of a color ? Don't know how to set it up like this ? Tag: VFP & Firebird SQL Tag: 214905

This is a multi-part message in MIME format.

------=_NextPart_000_0016_01C5A84E.32ABEA10
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

Hi,

Anyone using Firebird SQL with VFP ?=20

Plz advise on database update speed and tools used.

Regards
Hoe
------=_NextPart_000_0016_01C5A84E.32ABEA10
Content-Type: text/html;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-874">
<META content=3D"MSHTML 6.00.2900.2180" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Anyone using Firebird SQL with VFP ? =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Plz advise on database update =
speed and=20
tools used.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML>

------=_NextPart_000_0016_01C5A84E.32ABEA10--

Top