macro substitution

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
    - UNC problem I have an application that is located on a server LIVE in a directory MYAPP. All of the users will login and map the S: drive to \\LIVE\MYAPP. All of the application files and subdirectories are under this main directory. The application DOES NOT use any UNC paths to find files. The application will always look under the S: drive for files and directories. I wanted to create a test login for this application. I copied the entire application along with the data files to another share (TESTAPP) on the LIVE server. The test login will map the S: drive to \\LIVE\TESTAPP. When the test login is initializing variables, it looks for a "Variable save" (.mem) file to load the variables and values. This .mem file DOES not exist on the test environment, but does exists on the live application. So stepping through the application on the test login, the application set a variable equal to the mem file name. gf_memfile = "S:\MEMFILE\AMEMFILE.MEM". The application then tries to verify the file exists with the FILE() command. It returns .t. even though the file does not exist! The value of gf_memfile remains equal to "S:\MEMFILE\AMEMFILE.MEM". The next statement is a RESTORE FROM command that executes without an error. The gf_memfile variable gets changed to \\LIVE\MYAPP\MEMFILE\AMEMFILE.MEM!!!! Why is that? Where does it get the UNC from? I don't believe this is a Foxpro problem, but rather an OS problem, but I can't be sure. Any ideas? <snip> ..... gf_adrive = 'S:\' gf_memfile = gf_adrive+ "MEMFILE\AMEMFILE.MEM" IF FILE(gf_memfile) && does not exist, but this returns true RESTORE FROM (gf_memfile) && this statement changes the gf_memfile && to a UNC pointing to the live application! ENDIF ..... </snip> HELP!!! Tag: macro substitution Tag: 180776
  - 2
    - VFP to VB6 Hi I'd a software written in Visual Foxpro 6 and now in the process of converting the source codes into VB 6. I made use of lots of subclassed controls in my software, like embedding a Checkbox, Command Button, Image or Combo Box into some columns of a Data Grid. Is there a way to realize these functions in VB 6 without buying other 3rd-party OCX controls ? Thanks a lot in advance. Tag: macro substitution Tag: 180771
  - 3
    - Data Navigation Hi I have been a Visual Foxpro programmer for a few years and now looking for a way to convert those VFP written system into VB6. I have some degree of knowledge in ADO as I did write some Web-based database applications in ASP using ADO as a data access interface. I faced some difficulties in designing a Data Navigation Interface in VB6 coz I can't directly retrieve and bind a million of records into data-bound controls. In VFP 6, I simply used the following syntax to open a table and then directly set the RECORDSOURCE of control to the STUDENT will do, need not bother too much about the criteria in the retrieval of records. A simple Data Navigation Interface with searching features is then easily created in VFP. USE STUDENT IN 0 INDEX STUDENT SHARED In VB6, I need to think of lots of data retrieval criteria. If I used the following ADO syntax to retrieve the STUDENT data will take me 10 minutes for the whole process and might cause system hanging as well. SET rsA = cnA.Execute "SELECT * FROM STUDENT" In such scenario, the data is then broken down into smaller parts by putting a WHERE clause as below. SET rsA = cnA.Execute "SELECT * FROM STUDENT WHERE YEAR_ENROL = 2000" The Data Navigation Interface will only have the recordset of those students enrolled in the year of 2000. What if I want to search for a student by name "LESLIE WILSON" who actually enrolled in 2001? Of course, the rsA.Find syntax is not applicable in locating this student. In this case, I shall use rsA.open "SELECT * FROM PATIENT WHERE NAME = 'LESLIE WILSON'" However, by using this syntax, the Data Navigation Interface will then only have this student record. I found this is not a nice method. In VFP 6, I don't need to bother so much by using SEEK. What's the proper way of handling this issue in VB using ADO ? Thanks a lot. Tag: macro substitution Tag: 180770
  - 4
    - cursor shape in vfp6 Hi! I am using vfp6.0 in windows 2000 os. Whenever I starts vfp6.0, I finds my cursor shape to be vertically thin. Sometimes, I even can't identify its position on screen. I want to change cursor shape. i.e. It should be solid shaped, and in different color like red,green etc.Would you like to give any help regarding the above problem. Thanks Pushpak. . Tag: macro substitution Tag: 180753
  - 5
    - Error 1104 on zipfile, pls kindly help Hi, My application just only unzip some file and post them to my database file. However, it might after a day, will give error of 1104, Error reading file when going to unzip the zip file. Normally, before unzipping the file, I will tried to test whether the zip file is still posting half way by my client by fopen it to ensure that is is okay to open it exclusive first. After that, I use Dynazip to test it integrity before unzipping the file, but error 1104 still happen to my application. I am using VPF5a with Dynazip v4 running on Win98/95 with my zip file on my NT server share folder. Any possible cause of why this problem is happening ? I am at a loss. Tag: macro substitution Tag: 180750
  - 6
    - Reports produce different results every time I have a client with a very large database. Some of the tables has about half a million or more records in them. When I run a report using any of tables, I get different results on every workstation. It is also different on the same workstation if I run it multiple times. If I run it on the server, it is fine. Write caching has been turned off on all workstations. The server runs Windows NT 2000 and all the workstations have different versions of windows on them. Is there any other type of caching that needs to be turned off or has anyone else experienced this problem ? TIA Sujata Tag: macro substitution Tag: 180747
  - 7
    - XML to single or multiple cursor(s) I have a project where I have to link our application to QuickBooks for updating records in either application or inserting transactions in to QB. US version of QB SDK had a foundation class and XML options and I used FC, which had simplified my task but Australian version only supports XML. I need to be able to create single and/or multiple cursors depending on the XML dataset so that I can manipulate data easily in my application. I experimented with the response xml file and find out if I only have 1 level of tags XMLTOCURSOR nicely creates a cursor that corresponds to the xml structure except the variable types (eg. a datetime field was created as a character field). Eg. A response xml file from QB <?xml version="1.0" ?> <QBXML> <QBXMLMsgsRs> <TaxCodeQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK"> <TaxCodeRet> <ListID>20000-1046324474</ListID> <TimeCreated>2003-02-27T16:41:14+10:00</TimeCreated> <TimeModified>2003-02-27T16:44:08+10:00</TimeModified> <EditSequence>1046324648</EditSequence> <Name>CAF</Name> <IsActive>true</IsActive> <Desc>Cap. Acq. - GST Free</Desc> <Tax1Rate>0.00000</Tax1Rate> <Tax2Rate>0.00000</Tax2Rate> <IsTax1Exempt>false</IsTax1Exempt> <IsTax2Exempt>false</IsTax2Exempt> <IsPiggybackRate>false</IsPiggybackRate> <IsECVatCode>false</IsECVatCode> <TaxType>5</TaxType> </TaxCodeRet> <TaxCodeRet> <ListID>D0000-1046324474</ListID> <TimeCreated>2003-02-27T16:41:14+10:00</TimeCreated> <TimeModified>2003-02-27T16:44:08+10:00</TimeModified> <EditSequence>1046324648</EditSequence> <Name>NCI</Name> <IsActive>true</IsActive> <Desc>Non-Cap. Acq. - for making Input Taxed Supplies</Desc> <Tax1Rate>0.00000</Tax1Rate> <Tax2Rate>0.00000</Tax2Rate> <IsTax1Exempt>false</IsTax1Exempt> <IsTax2Exempt>false</IsTax2Exempt> <IsPiggybackRate>false</IsPiggybackRate> <IsECVatCode>false</IsECVatCode> <TaxType>3</TaxType> </TaxCodeRet> </TaxCodeQueryRs> </QBXMLMsgsRs> </QBXML If I use XMLTOCURSOR function without any modification I will get either one field or as many as the number of requests in the returned XML file (I can send multiple queries to QB in one XML message and therefore get a multiple response in one XML returned message) with everything squashed in with out their tags. Now if I remove <QBXMLMsgsRs> and <TaxCodeQueryRs .....> lines and also corresponding end tag lines then use XMLTOCURSOR function it will give me a cursor with field names and properties as ListID (char 16), TimeCreated (char 25), }these two is datetime field in the original XML response file TimeModified (char 25), } EditSequence (num 10), Name (char 3), IsActive (logical), Desc (char 47), Tax1Rate (num 8), Tax2Rate (num 7), IsTax1Exempt (logical), IsTax2Exempt (logical), IsPiggybackRate (logical), IsECVatCode (logical), TaxType (num 1) I can then work with this table to get what I want. This is fine if I only deal with one request/response, but majority of response(s) have more complex structure. Is there a better way to deal with response XML files? I saw in VFP8 new features that there is XMLAdaptor class that can accept internal or external schemas and create single or multiple cursors but we have some stability issues running our application in VFP 8 and therefore not ready yet to go up to VFP8. I need to find a solution within VFP7 capabilities. Cheers Mehmet Tag: macro substitution Tag: 180736
  - 8
    - VFP 7 How to change command button text color How do you change the text color of a command button programatically? I've tried to change the forecolor property, but that doesn't work. Thanks, Cliff Tag: macro substitution Tag: 180733
  - 9
    - send me spam plz zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com zaitsev@mail15.com Tag: macro substitution Tag: 180730
  - 10
    - _screen function Hi guys, I have create an object to display it as my background using the _screen.createobject command line. I had went through the help file but nothing in there tell me how to create the screen such that it will maximise to fill up all the white space. I can drag the size to fill the screen size but my concern is that if this were to implment to many customer, this might not look good since chances are they does have the same screen setting as mine. Mine is 1024 X 768 pixel Thanks a lot Best Regards Edwin Chua Tag: macro substitution Tag: 180729
  - 11
    - resizable frames within a form Hi, I need to create 3 or 4 frames(windows/sections/divisions) within a form that the user can adjust in an easy way. think about the 2 or three frames we usually have in Outlook or Outlook Express... the user just drag the frame borders with the mouse and the other frames ar also automatically adjusted right now the only way I have found to solve this is using one Formset with several forms and puting some code in the resize event of the forms to adjust the others, however there is a problem: the only visual container of the forms is _screen, it seems there is no way to put the forms inside a single form object that contains them so I can instantiate the same form with it´s internal adjustable frames and allow the user to look at them as many software allows: Mosaic or Cascade I know this should be possible becaus e I have seen an application developed this way (I guess in Microsoft C++), but I am not sure what controls are they using I would appreciate any advice or if somebody knows where can I download a similar sample from the net Thanks and Best regards Tag: macro substitution Tag: 180722
  - 12
    - SQL server connection Hello everyone.... how will i know if my sql connection which i made from the start of the program is still active. i need this to avoid errors that the said connection isn't active anymore. tnx a lot. Tag: macro substitution Tag: 180692
  - 13
    - Are there any drawbacks if I use a lot of connection to SQL Server (and not sharing them)? Hi all, Most of the connections I used in my apps are occupied by one SQL query (VFP's remote view). However, in a case where I need atomic transaction, I would share a connection and perform table insertion/update inside SQL's BEGIN TRANSACTION and SQLCOMMIT pair. Question: Are there any drawbacks if I use a lot of connection to SQL Server (and not sharing them)? Overriding the connection handle in VFP's remote views require coding in the form's Init event. If the drawbacks are acceptable, I'd rather bind the RVs in the DE than open it programmatically one by one. Please note that what I mean a lot is about 10 to 25 connection (remote view) in each form. TIA, Willianto Tag: macro substitution Tag: 180689
  - 14
    - General Question about hWnd Hello - is it possible to pass the hWnd to an activeX control for standard VFP objects? I can't seem to do it. In other words...... thisform.cmdButton.hWnd or thisform.lblBase1.hWnd Thanks. Mike Tag: macro substitution Tag: 180684
  - 15
    - launch explore from command line Hello again all I am converting reports to HTML and I know I can launch internet explorer from an icon on a screen but is there a way to launch it from the command line after the report has been created? Hope this makes since. Glen Tag: macro substitution Tag: 180672
  - 16
    - SQL error: GROUP clause missing or invalid This SQL statement which works fine in VFP7 generates a SQL error: GROUP clause missing or invalid when run in VFP8 SELECT Astu.status, Acls.classlink, amst.sectionid, ; count(*), amst.meetperiod ; FROM astu INNER JOIN acls ON Astu.stulink = Acls.stulink; INNER JOIN amst ON Acls.classlink = Amst.classlink; WHERE astu.status=' ' ; GROUP BY amst.sectionid ; INTO TABLE temp (Note: This is just a subset of the full SQL statement. Neither the full one, nor this one, work in VFP8) What do I need to change to make it work in VFP8? Thanks. Tag: macro substitution Tag: 180659
  - 17
    - VFP6 data type mismatch on selecting table an VFP6 application that has been running for a number of years, quite happily, which I am now doing further development on has suddenly started to come up with the error "data type mismatch" when I try to select a cursor that I am scanning through - either within the scan or at the endscan stage. I suspend the program then immediately click resume and it selects the cursor and carries on quite happily - right through to the end of the scan. I can't see any fields that could be suspect, they are all character and just a simple select with no function calls. It happily starts the scan. This is totally doing my head in. I had a sircam.worm infection a couple of weeks ago which I sorted out with Norton's help and the problems seem to have been going on since soon after that. Anybody come across/sorted out this problem? Tag: macro substitution Tag: 180651
  - 18
    - Creating User-Defined functions in Crystal Reports 8.5 or 9 via VFP 7 Automation Server I have Craig Bernston's book CrysDev and have downloaded several PDF's from Crystal Decisions and must be missing something. This appears to be a pretty simple process as described by both sources. However, I have built by VFP automation server, registered it, verified naming conventions and that Crystal has my DLL in use when in the designer, but my functions simply are appearing in the Crystal additional functions list. The behavior is the same for both Crystal versions 8.5 and 9 using VFP version 7. Any tips or suggestions would be appreciated. Thanks, Rory Sawtelle Tag: macro substitution Tag: 180645
  - 19
    - Softwarekey, Protection Plus, FPW2.6 I need to supply an old FPW2.6 application but add software protection. I have got Protection Plus from Software Key, and am having difficulty getting it to work using the KEYFOXW.FLL. I know it's old stuff but is there anybody who can guide me through the process of providing a 30-day demo which can then be unlocked to full version? Many thanks Stephen Ibbs Tag: macro substitution Tag: 180639
  - 20
    - VFP7 Multi-user View problems We are using some views in our system for combining files for using in a grid. When 2 users are inputting data on these forms, each user cannot see the other user's added records until they exit the screen and come back in. Is there a way of forcing the view to refresh from the server data? I don't really want to close it and reopen it as this may slow things down. Bernie Tag: macro substitution Tag: 180638
  - 21
    - Active SQL Connection Hi. Is there a way to determine if a connection to an SQL server is still active? Im using VFP 8.0 and MS SQL Server 7.0. Tnx!!! Tag: macro substitution Tag: 180636
  - 22
    - Slow down on XP SP1 Help i just install my application built by vfp7.0&vfp8.0 without any modification on win xp sp1, it runs extremely slow on connecting mysql database remotely or locally use odbc, but the program works fine on 98se, me, w2k, w2k server, xp without sp1, so i try to reinstall the win xp sp1 again without norton anti-virus software, and upgrade any service pack for xp, but still happen, i am using remote-view to connect mysql database, i discover, when the program is connecting database, the program will hang up for a long time, and occupy 100% CPU Usage, i have no idea about this problem. thks Tag: macro substitution Tag: 180627
  - 23
    - Background for report Is it possible to place a bitmap as a background for a report ? TIA Sujata Tag: macro substitution Tag: 180594
  - 24
    - Setup Wizard for exe files. I have been using the setup wizard in VFP6 to make up the installation CD to install applications. I see there is a better one out and wonder if I need to upgrade the VFP6 or can I obtain this newer wizard to make up the setup files?? I sure do like the ease at which VFP6 lets me make them up but is there something out there that I can use that is better? Tony Tag: macro substitution Tag: 180593
  - 25
    - Create Table - SQL This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C372FB.7C8059D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable VFP8/XP: I am creating a Binary Memo field in a table/DBF. When using "Create Table ..." SQL statement, there is no option to = distinguish a "Memo" field and a "Memo-Binary" field. Is VFP going to treat the momo field (which I create with the field type = "M") as "Memo-Binary" type based on the information I am going to store = in that field or what?! sp ------=_NextPart_000_0008_01C372FB.7C8059D0 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.2800.1226" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>VFP8/XP:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I am creating a Binary Memo = field in a=20 table/DBF.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>When using "Create Table ..." SQL = statement, there=20 is no option to distinguish a "Memo" field and a "Memo-Binary"=20 field.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Is VFP going to treat the momo field = (which I=20 create with the field type "M") as "Memo-Binary" type based on the = information I=20 am going to store in that field or what?!</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C372FB.7C8059D0-- Tag: macro substitution Tag: 180574
- Next
  - 1
    - Using a UDF in Menu's skip for Is there any way to reference the menu level, prompt, or command values in the skip for section of the menu designer? I want to create a database containing a record for each menu option, and the user ID's that have the authority to run each option. I could then place a used-defined function that queries this database to determine if the option is available. Tag: macro substitution Tag: 180567
  - 2
    - Overlaying a .wmf or other graphic over a .frx report Does any know how I can overlay a graphic file over a .frx report? This is what I want to do: I have a number of 81/2 X 11 forms (for example, export documents) that I want to generate from my Foxpro program. I have done this in Delphi by overlaying a .wmf on a report file and printing them both. This method generates a very professional looking form and is very useful in placing and aligning the data fields. However, because of the way VFP reports are generated (Header/Body/Footer/)inserting a full page graphic and overlaying the data fields seems impossible. If anyone knows how I can do this or something similar I would be forever in your debt. Thanks Pat Tag: macro substitution Tag: 180558
  - 3
    - Recording Table Changes I routinely receive updates to an existing table. I want to compare the old table to the new and record (in another table or view) only updated, added or delted records. I can write a program that will compare each record field by field, but can't help but think there might be an easier way. Any thoughts? Thanks Tag: macro substitution Tag: 180554
  - 4
    - Odd VFP6 behavior in XP Just noticed this oddity developing in VFP6 SP5 in XP Pro. Could be a video driver issue, but it only happens in VFP6, not in VFP8... Open a form for editing. Double click a control that has a resonably long chunk of method code in it. Select that method - the scroll bar in the edit window must be displayed. Click and drag the scroll bar a bit and DON'T RELEASE THE MOUSE. Keep the mouse button down, but keep the mouse still. In my system, after about 6 seconds, all of the windows in the VFP IDE go blank and stay blank until the mouse button is released. Thankfully the same thing does not happen in a VFP app at runtime. Still weird though! -- TRW _______________________________________ My e-mail: t r w 7 @ i x . n e t c o m . c o m _______________________________________ Tag: macro substitution Tag: 180553
  - 5
    - PRTINFO() How can I make a form print in landscape, thru a .prg file. I have tried PRTINFO(1) to no avail. Thank you Tag: macro substitution Tag: 180544
  - 6
    - win32api GetTempPath() on win98 Hi, I have been using the win32 api call GetTempPath() which has been working correctly on my development machine (Windows XP). How ever when tested on a Windows 98 machine the function returns an empty string, I know the winapi function works on win98 because I have used it in the past with various other languages. Please help! Thanks Chris Tag: macro substitution Tag: 180531
  - 7
    - Passing array to DLL Hi, I have a litte problem with passing and getting back values of an array passed to a dll (everything is VFP code). Here is my sample, and what happened. My DLL (a project compile as dll) Define Class ArrayToDll as Custom OlePublic Function GoArray lparameter pTableau Dimension pTableau(3) pTableau(1)="One" pTableau(2)="Two" pTableau(3)="Three" Return pTableau EndFunc Procedure ProcessArray lparameter pTableau Dimension pTableau(3) pTableau(1)="One" pTableau(2)="Two" pTableau(3)="Three" EndProc EndDefine and the code that uses the DLL ... i want to get back an updated array (dimension and values) Procedure ClientArray Local oObjetDLL,lTableau oObjetDLL=CreateObject("ArrayToDll.ArrayToDll") Dimension lTableau(1) lTableau(1)="Zero" lTableau=oObjetDLL.GoArray(lTableau) Dimension lTableau(1) lTableau(1)="Zero" oObjetDLL.ProcessArray(@lTableau) Release oObjetDLL EndProc I tried two methods, getting my updated array by value or by reference. In both case, i only get back an array with one element but with updated values. In fact, i get back the number of elements i passed, not an array with an updated number of elements. I got a solution with putting my array in an object and passing the object ... i just wanted to know if someone had to deal with such a case and how you solved it ... a solution with just passing array seemed to me more to read and understand ... Bests regards. Tag: macro substitution Tag: 180523
  - 8
    - Put a "date" date into a string and print in the report! Hi All, I have created a grid window and the data have been stored in a cursor. Also, two text fields (datatype: Date, Name of Text Fields: Text1,Text2) have been added in order to list the selected area only in the grid window. I'm now having a little troubles of how to print the selected data in the report. I want to list a sentence with "Text1" and "Text2" data ("date" datatype) in two text fields to the report like: filter_print='The date from'+allt(thisform.text1.value)+' to '+allt(thisform.text2.value) *!* This command is written in "Print" and "Preview" button. After I compile and execute the program, an error message jumps out and said "Operator and Operand do not match!" (It may not exactly the message like this!) The reason is because "date" data cannot be inserted into the string. So what's the correct statement should be looked like? Please help. Sam. Tag: macro substitution Tag: 180519
  - 9
    - Microsoft Windows Image Acquisition (WIA) Automation Layer Does anyone have any experience with Microsoft Windows Image Acquisition (WIA) Automation Layer - I would like to be able to scan & save images from my vfp6 app Thanks John Tag: macro substitution Tag: 180510
  - 10
    - WORD - CustomDocumentProperies I am looking for de VFP code to set the CustomDocumentProperties in a Word document. TIA Martin Lans Tag: macro substitution Tag: 180497
  - 11
    - SQL download I'd appreciate if someone can help me out on my dilemma: I would like to know what are the steps/commands to use to download data queried from SQL table, create output DBF that I can process in my Foxpro. Thanks for your help. Deo Tag: macro substitution Tag: 180490
  - 12
    - Catching error c05 when opening corrupted indexes Catching error c05 when opening corrupted indexes The problem is that I need to catch the error when I execute an USE command that opens a table with a corrupted index file. Normally Fox just gives me C0005 and exits. Any sugestion for any Visual FoxPro version from 6 to 8. Regards, Bastian Tag: macro substitution Tag: 180488
  - 13
    - Double Ampersand in Pull Down VFP8 I have a drop down control that is being populated by a field from a table. In one of the records the field being displayed has an ampersand in the text. When you pull down the list it displays two ampersands and not just the one that is in the field. e.g. The field text is: Barnes & Noble The pull down list displays: Barnes && Noble. What is going on and how can I stop this. Versions prior to VFP8 did not do this. Thanks Tim Cairns Tag: macro substitution Tag: 180484
  - 14
    - Eltron Programming Language/Foxpro 8.0 I'm interested in printing bar codes on Zebra LP2844 barcode printer. Can I access the Eltron Programming Language (EPL2) via Foxpro 8.0? Do I still need to buy a barcode font package or is this included? Thanks in advance. John. Tag: macro substitution Tag: 180478
  - 15
    - #DEFINES in VFP 8.0 - Bug? Hello, today I discoverd a stupid behavior in VFP 8.0. Could anyone confirm the following problem? > VFP 7.0 SP 1 ---------8<-------------- #DEFINE TEST "Hi" ? "TEST" && TEST ? [TEST] && TEST --------->8-------------- > VFP 8.0 ---------8<-------------- #DEFINE TEST "Hi" ? "TEST" && TEST ? [TEST] && HI --------->8-------------- Thanks Marco Tag: macro substitution Tag: 180462
  - 16
    - How to start Mobile Device Programming using VFP 7 Tag: macro substitution Tag: 180454
  - 17
    - Nested Scan w/in Procedure Is it possible to do the following: -scan through a table (table A) -use values in that table (table A) to pass as parameters to a procedure -within the procedure, open another table (table B) and scan through records in table B I get a scan/endscan nesting error. Thanks, -Jeremy Tag: macro substitution Tag: 180438
  - 18
    - Never before seen error in VFP6 Report Writer During the past week I am repeatedly getting a fatal exception while designing reports (with the VFP 6 report writer.) I'm running on XP and the error message provides no useful info - just shuts VFP down. I am trying to determine if the problem is unique to my PC or if it might be related to a recent XP update... Has anyone else seen this? Tag: macro substitution Tag: 180437
  - 19
    - access to task manager info from VFP? Hi. somebody knows how to aget the list of active processes as can be seen on the Windows 2K task manager from a VFP program? thanks in advance Oscar Taboada Tag: macro substitution Tag: 180432
  - 20
    - Printing memory and OT: Tracker PDF-Xchange Hi all, I've had memory issues nagging me for some time now on printing large volumes of VFP reports. What I've got is a billing program that spins through a few thousand customers and prints one or two copies of their bills--always one in PDF format the other (printed in about 2/3 of the cases) a postscript file. These bills consist of usually between three and six different formats (one frx each) with occassional bills having ten or even 15 different formats. So in the course of an entire run, it will probably run 15-25,000 REPORT FORM commands. As it runs, the MEM usage (from the Task Manager's Performance tab) continues to climb. However, if I do all the other processing, skipping the printing portions, the MEM usage change is negligible. My guess is the issue is more in printing when drivers are needed as we used to report to ASCII from frx's and never had these problems. I think I've got the most up-to-date drivers installed (Win2K Pro machine, HP5 printer/Acrobat 6.0 writer) and the app is currently running under VFP7. Upgrading it to V8 is a possibility, but in some short tests this morning, I've been seeing similar memory problems. Does anyone know of other places I might want to look or am I pretty much stuck trying to keep drivers as current as possible and keep setting stop-points and rebooting? Somewhat related: has anyone used Tracker Software's PDF-Xchange for printing w/ VFP. We're considering it as a replacement for Adobe's driver. The reviews I've found are few, but positive. I'm concerned mainly with accuracy, performance, then file size (though 1 and 3 so far sound good). TIA, John Tag: macro substitution Tag: 180431
  - 21
    - Subquery returned more than one record VFP8 SET ENGINEBEHAVIOR 70 or 80, doesn't matter. The below query (the below is a portion of the query, the entire query has some joins, etc.) has worked in previous versions of VFP. I'm now getting the error "Subquery returned more than one record" SELECT AcctCode,Dept,Revenue,Income ; FROM JobCost ; WHERE Dept=(SELECT Dept FROM ValidDepts WHERE Dept="4") ; INTO CURSOR TempCost The subquery does return more than one record, but it worked in the past. Even if I force the subquery to return one DISTINCT record, I still get the error. Help anyone. Thanks in advance Tim Cairns Tag: macro substitution Tag: 180422
  - 22
    - Date/Time from the server Is there a way to pull the date and time off a server and not the local machine? Date() pulls the date off the workstation. I would like to synchronize the Date/time with server. Thank you. NMenon Tag: macro substitution Tag: 180413
  - 23
    - Number Format This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C3716D.C5D4AFD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I would like a function which presents the numbers as follows: 10,00 Gives 10=20 10,05 Gives 10,05=20 0,00 Gives 0 ( 2 decimals) It is a function to be placed in the controlsource of a column. Thanks a lot in advance bernhart ------=_NextPart_000_0010_01C3716D.C5D4AFD0 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.2800.1226" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I would like a function which presents = the numbers=20 as follows:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>10,00 Gives 10 </FONT></DIV> <DIV><FONT face=3DArial size=3D2>10,05 Gives 10,05 </FONT></DIV> <DIV><FONT face=3DArial size=3D2>  0,00 Gives 0</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>( 2 decimals)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>It is a function to be placed in the = controlsource=20 of a column.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks a lot in advance</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>bernhart</FONT></DIV></BODY></HTML> ------=_NextPart_000_0010_01C3716D.C5D4AFD0-- Tag: macro substitution Tag: 180409
  - 24
    - Programming with ProjectServer and VFP Dear Listmembers, I want to program with the Project Data Service (Middle-tier) to require access to Microsoft Project tables on a Microsoft Project Server 2002. All the examples are written in VB of C#. Has anyone experience with VFP and the PDS? TIA, Jan Vente Tag: macro substitution Tag: 180389
  - 25
    - Desarrollador Visual Foxpro8 Solicito desarrollador para proyecto en Visual Foxpro 8.0=20 en la ciudad de M=E9xico DF, pago por honorarios,=20 interesados favor de mandar su curriculum vitae, asi como=20 la cotizaci=F3n por hora de programaci=F3n. Sin m=E1s por el momento, quedo a sus =F3rdenes Tag: macro substitution Tag: 180386

I have the followig code in a routine, which i neeed it to
refresh data in different forms, having objFormName= to
the form name.

&objFormName..GridSignOff.RecordSource='rv_view_singOffList
VirtualSql'
&objFormName..GridSignOff.Refresh()

Everithing works well, but when I compile the application,
I get a message stating the the form name contained in the
variable objFormName is not an object.

What i am doing wrong here?
Can anybody help before i perform a "MACRO SUBSTITUTION"
to my monitor?!

Top

Re: macro substitution by mappell917

mappell917
Mon Sep 08 12:22:39 CDT 2003

Hello - first of all, it does not seem like you should need macro substitution
in your routine. Why not just set a variable or property to the form object.
Example:

loForm = thisform

loForm.GridSignOff.RecordSource = etc etc

But, if you insist on macro substitution, try setting objFormName to
"thisform.GridSignOff.RecordSource"

But - you should not need macro substitution at all.

Regards

>I have the followig code in a routine, which i neeed it to
>refresh data in different forms, having objFormName= to
>the form name.
>
>&objFormName..GridSignOff.RecordSource='rv_view_singOffList
>VirtualSql'
>&objFormName..GridSignOff.Refresh()
>
>Everithing works well, but when I compile the application,
>I get a message stating the the form name contained in the
>variable objFormName is not an object.
>
>What i am doing wrong here?
>Can anybody help before i perform a "MACRO SUBSTITUTION"
>to my monitor?!
>
>
>
>
>

Mike

Top