Converting VB code to VFP (Using SAPI)

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
    - Open Word file in Vista I have another problem with an application that runs OK in XP, 98, and 95 but not Vista. I open a Word.doc file from a command button in a form as below in XP, 98, or 95 and the Word doc file opens and displays on the screen so the user can enter a letter in Word. When I use the same file in Vista it pops up on the task bar and the user has to click on the task bar to open the file up. oWORD = GetObject(MYLOCATION+'\'+'C_FILE_NUM+'.DOC') WITH oWORD .APPLICATION.WindowState = 1 .APPLICATION.VISIBLE = .T. ENDWITH No problem staring up Word with the document but it always ends up on the task bar when run in Vista. Is there something to add so it will open up without the user having to click the taskbar?? Tony Tag: Converting VB code to VFP (Using SAPI) Tag: 236446
  - 2
    - RUN xcopy COMMAND IN VISTA I have been using the RUN xcopy in an application using variables with no problem until I installed it in a Vista Operating system. from = "C:\PFILES\*.*" to = "C:\BACKUP" RUN XCOPY &FROM &TO &&This works OK in XP or 98 but not in VISTA This will run in VISTA RUN XCOPY "C:\PFILES\*.*" "C:\BACKUP" If I try and use the variables like in XP it will not run. There is no error but the command window comes up and then shuts down. I need the variables as they are field inputs that the user enters. Any suggestion would be appreciated. TonySper Tag: Converting VB code to VFP (Using SAPI) Tag: 236429
  - 3
    - RUN Question I still have yet to learn about ShellExecute and would like to continue to use the RUN command because of the ability to leverage the "File Association" aspects of windows. In the CMD.COM and COMMAND.COM environment using the windows start menu "run" command, from the command prompt; START <filename.ext> ...will launch the users application of choice for that file extension, but VFP's "RUN" command launches NTVDM.EXE which seems to be a pretty crippled command shell... START for one won't work. I can address this by replacing the FOXRUN pif with a copy of the windows DOS pif, but would like some wisdom on what NTVDM.EXE is and how others deal with it. Thanks in advance, Beverly Howard Tag: Converting VB code to VFP (Using SAPI) Tag: 236426
  - 4
    - VFP9: Trouble updating view Hello, I have two views, both utilizing the same table. The views are simple and based on a single common table. The only difference between the two views are the filter parameters. All the proper PK and update fields have been checked in the view builder. Both these views reside in the same form data environment. Both views use default table buffering. The trouble starts when I save changes to an exsisting record, it requires that I save the changes twice before the base table recieves the update. I'm stumped! John Tag: Converting VB code to VFP (Using SAPI) Tag: 236423
  - 5
    - Spinner Events (Still vfp7) First time using a spinner control and not understanding when the spinner sourcecontrol is updating... In this example, the spinner controlsource is a form property containing a numeric value. The resulting value is used in a SEEK which, if successful, updates the form. Question: When is the spinner controlsource updated? I'm finding that I have to run math on the value to execute the seek... for example; If it's a "DownClick" event, I have to subtract the increment from the controlsource to execute the seek for the expected value following a downclick. What concerns me more is that when trying to track this using the debugger, the value did, at some points, decrement during the processing of the downclick event. Thanks in advance, Beverly Howard Tag: Converting VB code to VFP (Using SAPI) Tag: 236422
  - 6
    - Drag and drop onto report builder I give my users the chance to modify reports within our application. They also have various data entry forms. It is possible to have both open at the same time. The ideal way for a user to add a new field to the report would be to go to the data form and DRAG the field from the form onto the report builder surface. That way the user doesn't have to think about the internal field name and all that stuff. Ideally, as it was being dropped, it would call some method or procedure in which I could examine the field (object) being dropped and return .T. or .F. to permit it. Also maybe to extract the field name from object dropped, and do other stuff. Any ideas how this might be done? Tag: Converting VB code to VFP (Using SAPI) Tag: 236420
  - 7
    - Network Messages I'm writing a program that monitors a network directory for incoming ftp files. Is there a way to send messages to the users who need these file when they arrive? Hopefully, I can do this without installing the monitoring app itself on all their desktops. -- -Lew The workers took the robot for Maria. Tag: Converting VB code to VFP (Using SAPI) Tag: 236410
  - 8
    - Get Paper Name & Orientation from Crystal Report Hi, i am using visual foxpro 9 ith crystal report 11 R2. to open report i use ; crxreport = crxapplication.openreport("test.rpt") now how i get the paper name, paper size, orientation & report file name from foxpro. thanks Tag: Converting VB code to VFP (Using SAPI) Tag: 236408
  - 9
    - Modify Report - failure and error message A report is stored on the server. Various users on the network want to modify the report from time to time, and run it. They Modify Report from their Command Window and are in the Design view. Then they can switch to the Preview view. Here is where the error comes in. Some users can then switch back to the Design view to keep tweaking the report, and switch back to Preview. That is, they can switch back and forth between Design and Preview. Other users can switch from the initial Design, and then to Preview, but when they try to switch back to Design, the process crashes with an error which reads: ! Cancel. OK Help The exclamation mark is in a yellow triangle, and the whole thing is in a rectangle. This is a strange message which says nothing. Now this is really an insignificant error, because the users can go right back from the Command Window into Modify Report. Still, it's bothersome, and it makes one wonder what's going on? By the way, all users have a full copy of VFP 6.0 installed on their local machines. Tag: Converting VB code to VFP (Using SAPI) Tag: 236371
  - 10
    - ODBC: Is this a bug? vfp 9, SP1 The point of the following was to determine if an ODBC connection is available on the current machine and it works fine for that purpose. However the added ? statements show what seems to me to be a bug. ? DBUSED('lms_logger') && returns .F. TRY USE (odbc_path+'lms_logger!header_view') IN 0 ALIAS test rtn=.T. CATCH rtn=.F. ENDTRY IF rtn USE IN 'test' ENDIF ? DBUSED('lms_logger') && returns .T. * * However, if you try to create an SQL view at this point, it throws an error * that no database is open * CLOSE DATABASE ? DBUSED('lms_logger') && still returns .T. OPEN DATABASE (odbc_path+'lms_logger) CLOSE DATABASE ? DBUSED('lms_logger') && is now F There is probably a better way for me to test the connection. And, this is easy enough to work around. Still, it seems to be odd behavior. G Tag: Converting VB code to VFP (Using SAPI) Tag: 236363
  - 11
    - Report Preview When you send a report for preview is there a way of eliminating the command box that appears in the upper left corner that allows the closing or printing of the report?? The reason is that I first let the user preview the report and then after they close the preview I bring up a message box that asks if they want to print the report. It appears that some users print the report to close it and then print the report again. Some user get confused easy. Thanks for any suggestions. TonySper Tag: Converting VB code to VFP (Using SAPI) Tag: 236362
  - 12
    - Grid not following A while back posted and discussed a VFP7 problem concerning a form where the grid and current record pointer was not being maintained following actions such as an index change but never really addressed it because of the need to meet other needs. Tinkered with it today and found that even though the thisform.refresh does nothing related to record position, the solution turned out to put the "goto <recordnumber>" _after_ the form refresh. hope this helps, Beverly Howard Tag: Converting VB code to VFP (Using SAPI) Tag: 236358
  - 13
    - ActiveX and Socket Programming Has anyone used sockets with VFP? In particular, I have the mabry socket control and I'm trying to understand how to send and receive files. I know how to open the socket and use the methods and events to instant message and send a small packet of data over the LAN or the internet but I don't understand how to send a large file. I can't use FTP because I want to send the data directly to an IP address on a LAN via the internet in my application. It seems that the size of the buffer is around 8K by default but I'm confused as to whether the host tells the client "I'm ready for the next packet" or does the client just send the data to the host. Is there some standard protocol for this and also how does the host know when all the data is received since when opening a socket one can continue endlessly sending data? Thanks, Mike Tag: Converting VB code to VFP (Using SAPI) Tag: 236324
  - 14
    - Total to <Fieldname>... is <FieldExpr> ok? I'm looking at some old code that uses the total to command. The help file specifies that the syntax is total to <TableName> on <FieldName> (ie group on a single field value), but the code I see uses a field expression, ie <Field1+Field2+Fieldx+etc>. It seems to work ok. Can anyone confirm that this will always be the case or are there gotcha's.... like what happens when the FIeldExpression reaches a certain length or the actual field widths exceed a certain total. -Lew Tag: Converting VB code to VFP (Using SAPI) Tag: 236322
  - 15
    - replace syntax I am issuing the below syntax, and the result is it not only changes what it is supposed to, but also records where groupid = 54 REPLACE ALL groupname WITH "Customer Cell Numbers" FOR groupid = '5' Tag: Converting VB code to VFP (Using SAPI) Tag: 236314
  - 16
    - Slow Accessing a memo field on a network Anyone have any ideas about this: here's the situation, I have a memo field that I use in a table and I read various lines from the memo field for default settings. This makes it so that I don't always have to modify the structure of the table. The total length of the memofield is small (under 3K). However, I have to read the memo field multiple times to get the default values on any particular line. For example: set memowidth to 8192 test1 = mline(mytable.mysettings, 1) test2 = memline(mytable.mysettings, 2) test3 = memline(mytable.mysettings, 3) test4 = memline(mytable.mysettings, 4) There are about 150 lines at present in the field. Here's the strange thing. I have a method in a form that reads all the values and sets the objects on the form accordingly. It seems like it is starting to take a long time to load the form (around 6-10 seconds). But, this delay is ONLY PRESENT if the table is open on another computer on the network. If I open the table on the same computer in a separate program (such as VFP) or I run another instance of my application, then everything is fast. The slowness only happens if the table is open on another workstation and it appears that it is just as slow if the table is open on 2 workstations or 10 (makes no difference). It drastically speeds up when the table is open on only one workstation and is fast even if that table is open on one computer with multiple programs (such as if it is open in my app as well as open in VFP). I have noticed this problem on both an XP Pro computer (as the server) with XP workstations and I have also noticed this problem on a real Win 2000 server with XP workstations. I'm using VFP 6/SP3. The problem only seems to happen when doing multiple reads from the same memofield many times. In other words, if I do this instead: m.lcMain = mytable.mysettings and I then populate the form using m.lcMain then everything is very fast. It's as if multiple reads to the same memofield is really slow but only if the table is open on another workstation. There are no virus checkers or other programs (that I know of) to slow it down). I can't understand why this is happening but I'm not sure if it is happening on other server OS's as well or just these few examples I have provided. I'm running the exe on the local machine. But, it seems to be some kind of network issue because the speed drastically slows down (reading the memo field multiple times) whether the table is open on two workstations or 10. It's then pretty much the same slow speed when open at 2 computers or more but lightening fast when open at only one. Anyone have any ideas? Thanks, Mike Tag: Converting VB code to VFP (Using SAPI) Tag: 236303
  - 17
    - Trigger How can I write a very simple piece of code in a delete trigger so that no orphans arise? The referential integrity builder is too complex, and crashes my VFP9 SP2. Walter Tag: Converting VB code to VFP (Using SAPI) Tag: 236300
  - 18
    - Validating data, tricky one... Hi: I need to validate that records have been entered correctly in a table, by correctly I mean in ascending order. But with a small variation, the first record can have any value, so: Field1 100 2 3 4 5 6 This is correct, because record 1 can have any value, but : Field1 88 2 3 7 5 6 Is wrong, can I validate this using VFP? Tag: Converting VB code to VFP (Using SAPI) Tag: 236289
  - 19
    - Validating data, tricky one... Hi: I need to validate that records have been entered correctly in a table, by correctly I mean in ascending order. But with a small variation, the first record can have any value, so: Field1 100 2 3 4 5 6 This is correct, because record 1 can have any value, but : Field1 88 2 3 7 5 6 Is wrong, can I validate this using VFP? Tag: Converting VB code to VFP (Using SAPI) Tag: 236288
  - 20
    - .net + fox com objects We have a program written in VB.net using the version 2 framework. The program uses a fox com object written using vfp8 and compiled as an exe. On our development machine everything works fine, it also works on SBS 2003 in our office. The problem is when we deploy it on our customer's SBS2003 machine we get the following error. The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) at satnavcom.htsatnavClass.set_CEXEPATH(Object CEXEPATH) at satnav.Form1.startdata() at satnav.Form1.DoWork() The error occurs at the point where a property of the com object is set. If I comment out the code which sets this property we get the same error but on the line which sets the next property. CEXEPATH in the exception above is the com object property it fails on. All necessary runtimes are on the machine and it is registered correctly. I have spent hours on this problem without success, has anyone come across any similar problems. I have tried giving everyone permission to this com object use dcomcnfg but it still doesn't work. TIA Dave Tag: Converting VB code to VFP (Using SAPI) Tag: 236279
  - 21
    - Locate vs Seek Command Hi: I have a small aplication that runs only with free tables. I have been hearing that CDX files could get corrupted for a number of reasons, but the only reason I need the indexes is for some seek commands to validate certain fields. My tables are actually small mostly on the range of 500 to 1000 cases. Is is a good idea to change the seek commands with locate commands in order to avoid generating indexes, are CDX files necessary on free tables. should I expect performance problems with this change? Thanks for your time!!! Tag: Converting VB code to VFP (Using SAPI) Tag: 236278
  - 22
    - Help: SQL remote view compare to local table Hello, having trouble with a solution to only query new records in a remote view and would like some help. Have a local table (free vfp table) with an ID field and a remote view to SQL table with the same ID field. What I want to do is change the remote view query to the SQL table to pull only records where the ID's do not match the local table. The reason is that this particular table contains 500,000 records and I'm trying to reduce the amount of data being pulled in the remote view itself. The result set would then contain only new records in the remote view since my last pull. No consideration needs to be made for changed records, just new records in the remote view as determined by an ID that does not match the local free table. I'm was thinking something like, use the remote view, use the table then a compare loop but that defeats the purpose as I'm still pulling all records in the remote view. Using the CREAT SQL VIEW and within the AS SELECT portion, can I reference data from the remote connection AND a local table at the same time? But if the local table isn't part of the remote connection won't that mess up? So the SELECT would be something like CREATE SQL VIEW 'MyView' REMOTE CONNECTION 'MyConn' AS SELECT RemoteViewTable.Field from RemoteViewTable where RemoteViewTable.Field = LocalFreeTable.Field? I suspect my approach is off....any ideas? TYIA =Ben Tag: Converting VB code to VFP (Using SAPI) Tag: 236273
  - 23
    - VFP 9: INSERT-SQL into a Table from the Same Table YA variation of "How do I do this with only ONE SQL statement?": The client billing app that I maintain has Work Function Codes (WFC) for the types of work that are performed. These have an expiry date (validtil). My boss now wants a program for automatically generating the next ones. I have a cut for the basic code. It takes three SQL statements. Is it possible to do it in one? goyear() is like gomonth() except that it works by years and it makes sure that YY-02-28 becomes (YY+offset)-02-29 when YY-02-28 is at the end of the month. WFCs are uniquely specified by funccode-clcode-wccode-validtil. The first cursor contains the WFCs that will be used to generate the new year's WFCs. This code allows for a WFC to lapse so that no longer used WFCs do not keep getting generated each year. (latestdt is the last day of the yearlong period for which the new validtil value can be. If it would not be in this range, then a new WFC is not to be generated.) ***** Start of Included Code ***** latestdt={^2008.12.31} select * from cwkf as out; where; clcode="BHU" and validtil=; (; select max(validtil) from cwkf; where; funccode=out.funccode and clcode=out.clcode and wccode=out.wccode; ); and goyear(validtil,1)>goyear(latestdt,-1) and; goyear(validtil,1)<=latestdt; into cursor togen readwrite update togen set validtil=goyear(validtil,1) insert into cwkf; select * from togen ***** End of Included Code ***** I could change the insert to specify each individual column and save having the update statement, but that is more trouble than it is worth. (Suppose I add a column to cwkf. Then, I would have to update this program, too.) What I am hoping for is a way to insert in one statement. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Converting VB code to VFP (Using SAPI) Tag: 236264
  - 24
    - Triggering an application from SQL Server? Hi, I was just wondering would it be possible to have a trigger in a SQL 2000 database launch a VFP application to print a label? I think setting up the trigger is pretty straight forward but having it launch a VFP application is more tricky. I guess the trigger would have to pass a couple parameters that the application would use for a look up. Is this possible and what would I have to do on the VFP end to make it work? Thanks in advance, Linn Tag: Converting VB code to VFP (Using SAPI) Tag: 236256
  - 25
    - combobox readonly? Just got bit by the fact that vfp7 didn't object to a combobox object being set to readonly within a method. ...turns out that doing so is ineffective and that the combobox will still change the control source in that state <sigh> So, on the surface, it seems as if the only direct option is to set the combobox to .not. enabled. However, that also precludes being able to view the combo box's contents, so, wondering if there is an easy way to allow the user to view the pulldown while preventing it from changing the control source? Thanks in advance. Beverly Howard Tag: Converting VB code to VFP (Using SAPI) Tag: 236251
- Next
  - 1
    - SQL help needed Hi, I'm having a hard time figuring out the best way to write an SQL query to do the following. I want to search a whole table (every field) for a word like "software" and filter it by multiple clients and vendors that the user has chosen. This is my SQL so far, but it doesn't work SELECT Etlpws.unqentry, Etlpws.category, Etlpws.client, Etlpws.vendor,; Etlpws.desc, Etlpws.wsaddy, Etlpws.wsfolder, Etlpws.wstaticip,; Etlpws.swprodname, Etlpws.swprodkey, Etlpws.swpurdate, Etlpws.swcategory,; Etlpws.swtype, Etlpws.swusers; FROM ; etlpws; WHERE ( ( ( Etlpws.category = ( "software key" ); AND Etlpws.client = ( "External Client" ) ); AND Etlpws.client = ( "My Company" ) ); AND Etlpws.vendor = ( "Microsoft" ) ); AND Etlpws.vendor = ( "IBM" ); AND Etlpws.desc LIKE "%software%"; ORDER BY Etlpws.client, Etlpws.fullname; INTO CURSOR Sw_query So I have 2 problems. 1. I can't figure out a way of telling the above SQL to search every field for my search term. I'm currently only testing using one field which is the 'desc' field. But need this to search all the fields. 2. The multiple where statements "AND Etlpws.client" end up displaying every record that matches the client name which is correct, but it's including records that don't have a matching "software" result found in the "DESC" field. So instead of getting 2 results, I end up with 58 records with the wrong data in it. I've tried changing it to say OR instead of AND but then this displays 0 results. Can anyone point me in the right direction? Thanks Tristan Tag: Converting VB code to VFP (Using SAPI) Tag: 236250
  - 2
    - Distributing my application? Hi, Ok, I'm now trying to distribute my application and I built the installer with install shield express. My original attempt worked fine, program installed and it ran. Then my users asked for a new feature, no problem I said and went to work. Added the feature, rebuilt the application and the installer. The only thing unusual that I did with the application was to add the datetime picker control. Now after installing my app. it doesn't work. It launches, I can see it listed in the task manager but nothing displays. No error messages, nothing in the event viewer. I'm not sure what to even look at. Any suggestions? Here is a list of the redistributables I have added to the installer: GDI Plus Redist module Microsoft C Runtime Library 7.1 Microsoft Component Category Manager Library Microsoft OLE 2.40 for Windows NT and Windows 95 Microsoft Visual FoxPro 9 Runtime Libraries Microsoft Windows Common Controls-2 (6.0) Is there something I'm missing from this list? What else should I be looking at? Thanks in advance, Linn Tag: Converting VB code to VFP (Using SAPI) Tag: 236248
  - 3
    - Print2PDF - Landscape and Legal Using VFP 9.1 and XP sp2 I've used Print2PDF for some time now and found it very useful. The only problem I've encountered until now is the VFP habit of storing printer info in the frx. But I guess I haven't tried making a legal, landscape report into a pdf. If I run the report using to printer prompt and select Acrobat PDFWriter I'm able to create the report in the page layout I need, but using print2pdf I'm getting a VFP message box: "Detail 1 band is too large to fit on page." Has anyone encountered this before? Any suggestions? I've looked through the documentation for landscape, paper size, orientation, etc. to no avail. Thanks in advance, Dave Tag: Converting VB code to VFP (Using SAPI) Tag: 236245
  - 4
    - back end data faster updates Hello! I'm still new with MS SQL and I tried to use the SQLEXEC() function to execute the STORED PROCEDUREs I coded at the SQL Server but when I tried to use the remote views I found out that its much faster than the SQLEXEC function. So I would like to ask for any suggestions about this, if the using the remote views in updating the data at the SQL Server is much faster compared to using the SQLEXEC function. Thank you. Ryan Paradela Tag: Converting VB code to VFP (Using SAPI) Tag: 236238
  - 5
    - Escape sequences My program is putiing a string onto the clipboard, which is then pasted by the user into a text field in another application. I would like part of it to be displayed in bold when pasted. In the DOS days, didn't we used to do this with an "escape sequence"? CHR(27) + ....? I can't see a way to do it now. Any suggestions would be appreciated. TIA Andrew McGurk Tag: Converting VB code to VFP (Using SAPI) Tag: 236237
  - 6
    - scheduling Group, Are there any task schedulers or activeX controls that can run inside an exe to schedule another exe to run without user action? Wade Tag: Converting VB code to VFP (Using SAPI) Tag: 236230
  - 7
    - Test Test Tag: Converting VB code to VFP (Using SAPI) Tag: 236210
  - 8
    - Messed up calculations. I have an inventory program that does complex interest calculations using several tables. The previous version was in VFP5. But for about a year now with VFP9 a few of my customers complain of ocasional wrong results. It seems random and I cannot reproduce it on my XP PC with their tables. Most customers don't seem to have the problem and run fine. Never had that problem with VFP5. Is there a bug in VFP9 that could cause that and/or in connection with other interfering software residing in memory? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: Converting VB code to VFP (Using SAPI) Tag: 236203
  - 9
    - Remote view with date parameter? Hi, VFP 9.0 sp1, I'm trying to build a parameratized remote view against a SQL 2000 backend where the parameter is a date. The field on the SQL table is of type datetime. My view looks like this: create view myview connection myconnection as ; select slip_number, date_printed ; from packing_slips ; where date_printed >= ?prndate My test code looks like this: prndate = date() use myview in 0 browse This returns many records with various dates, not just todays dates. I tried putting dtoc(date()) but that changed nothing. There must be a way to do this, any suggestions? The SQL table has slip_number of type varchar and date_printed as type datetime. When I run the code form the query analyzer I simply enter the date as '09-14-2007' and it converts automatically. Thanks in advance, Linn Tag: Converting VB code to VFP (Using SAPI) Tag: 236199
  - 10
    - Why isn't intellisense ON a default? The screwy installation I'm working has intellisense off by default, so I turn it on manually. Isn't there a way to save "on" as the default? -Lew Tag: Converting VB code to VFP (Using SAPI) Tag: 236183
  - 11
    - Report Preview Toolbar Hi, My user sometimes closes the report preview toolbar instead of the actual report. is there a way that if the toolbar is closed, the report will also close? Thanks, Herbert Tag: Converting VB code to VFP (Using SAPI) Tag: 236182
  - 12
    - String Search Is there a function that can do this: Search String as one expression only: "black white" Result I want to have: "black" "white "black white" "white black" "black blue white" Thanks Tag: Converting VB code to VFP (Using SAPI) Tag: 236177
  - 13
    - Common dialog with additional control? I need to display a common dialog with an extra checkbox for a user option. I have tried using the _comdlg class in VFP foundation classes. After dropping the comdlg on a form I have tried the following code: thisform._COMDLG1.AddObject('chkTest', 'checkbox') thisform._COMDLG1.chkTest.visible = .t. thisform._COMDLG1.chkTest.caption = 'MyCheckbox' thisform._COMDLG1.chkTest.top = 11 thisform._COMDLG1.chkTest.left = 11 thisform._COMDLG1.showdialog() Nothing happens, and I get no error messages. Can someone tell me what I missed? Tag: Converting VB code to VFP (Using SAPI) Tag: 236176
  - 14
    - Its urgent - half page report hi all, I have to make the layout of the invoice printing which should fit in half page. but the paper which i am using is A4. I always need to take two copies of invoice. Therefore, i want to use the upper size of paper as invoice with rates and lower size of paper without rates. please help me is it possible? Also is it possible to print the report twice on the same page. any other way of using half page layout. I hope i am clear in explaining my problem. In brief, how to print the report on half page? I tried to make the paper size as custom size but seems many printers are not supporting it. I mean after making it custom size, the paper size turn backs to original A4 size. any solution. Earlier i used to manage it by way of making report in foxpro under dos. Tag: Converting VB code to VFP (Using SAPI) Tag: 236175
  - 15
    - VFP? I'm puzzled. The rage in the development tools industry now is dynamically typed, designer languages, some even talking about command line interpreters coming soon. There is even a project working closely with Microsoft on a so called Dynamic Library Runtime (DLR) which works with the CLR that .NET is built on to facilitate creation of these dynamically typed languages. So here sits the worlds largest software house, strangling the last bits of life out of the world's greatest dynamically typed data oriented language. Is this another case like with the internet and security where Microsoft has completely missed the boat? Tag: Converting VB code to VFP (Using SAPI) Tag: 236172
  - 16
    - Southwest Fox conference 2007 North America's best Visual FoxPro conference will take place in Mesa (near Phoenix), Arizona. It is the place to be in October 2007 as the top VFP gurus on the planet show you how to make the most of VFP. http://www.swfox.net/ Place: Arizona Golf Resort and Conference Center, Mesa, Arizona Dates: October 18 - 21, 2007 Worth every nickel.... -- Message posted via http://www.dbmonster.com Tag: Converting VB code to VFP (Using SAPI) Tag: 236168
  - 17
    - Is rename always copy/erase? I can't find an api call for a simple rename, leading to my question: Is rename *always* a copy/erase function? -Lew Tag: Converting VB code to VFP (Using SAPI) Tag: 236159
  - 18
    - MSCOMM in windows 2000 server does the control fox 'mscomm' work in windows 2000 server? Tag: Converting VB code to VFP (Using SAPI) Tag: 236151
  - 19
    - How do I capture time input from a user in a 24 hour format How do I capture time input from a user in a 24 hour format without the date and seconds? I need to get the arrival time and departure time from a user and find the time in between. Thanks, Thorkell Tag: Converting VB code to VFP (Using SAPI) Tag: 236139
  - 20
    - Lost dev environment Hi All, All of a sudden my VFP has lost it's memory. Before, yesterday, when I would launch VFP the Task Manager would pop up and have a list of recently used projects. When opening a project all the tabs, Data, Documents, Classes, Code and Other, would open with all of the trees left in how I had them when using them previously. The editor windows would open sized the way I liked them, even the command window would be as I had it setup. All of a sudden, just today, everything acts like it had never been opened before. The task manager doesn't remember my recent projects, the All tab is the default and all the windows open small so I have to resize them to use them. What gives? The only thing I remember doing is compiling the application and creating an install routine with Install Shield Express. Any one know how I can recover my environment, or at least get VFP to remember it from session to session? This is VFP 9.0 sp1, BTW. Thanks, Linn Tag: Converting VB code to VFP (Using SAPI) Tag: 236136
  - 21
    - VFP to SQL via ODBC add records to table with key field Using VFP 9 remote view connecting to SQL 2005 via ODBC. On the SQL side I have a table with three fields, one is a primary key type BigInt, other two are text On the VFP side I have a remote view selected, append blank, browse, type in number to key, then text to other two. When I try and close the view it errors out saying the key field does not accept null values, but in the remote view it is not null and has a value. There is only one record added in the remote view. What am I missing? Tag: Converting VB code to VFP (Using SAPI) Tag: 236135
  - 22
    - Dumb Grid Question I would like to use a method to modify a specific cell's value using a cell click/rightclick event. Not seeing anything obvious with respect to taking action on a single cell... i.e. if the cell is readonly, is there a way to run a method on the cell when it's clicked/rightclicked? Feeling dumb again... help! Thanks in advance, Beverly Howard Tag: Converting VB code to VFP (Using SAPI) Tag: 236134
  - 23
    - Troubles in showing a web site which contains a flash animation I have developed a Visual FoxPro 6.0 application which has two forms. The first form has the following value "2 - As Top-Level Form" in "ShowWindow" property. The second one has the following value "1 - In Top-Level Form" in "ShowWindow" property; it also has the following value "0 - Off" in "TitleBar" property. So, the first form becomes the main window, and the second one is located inside the main window area. In the main window an ole control named "_webbrowser4" (based on "ShellExplorer2" class) is inserted for showing a website content. My aim is to show a set of banners, which are shown in a sequential way; these banners are animated gifs, jpgs and flash animations. In the second form I inserted a TextBox object for entering a string. The trouble is: when a flash animation is showed in the web site, the TextBox object loses the focus, which may cause an inconvenience to user who is entering data in a Textbox. I would like to know how I can avoid that "_webbrowser4" ole control (from the main window) gets the focus, when a banner with Flash is showed (this doesn't happen when a banner with an animated gif or with a jpg is showed). The ole control named "_webbrowser4" is located in the following class library: c:\Program Files\Microsoft Visual Studio\Vfp98\Gallery\_webview.vcx Thank you for your help. Tag: Converting VB code to VFP (Using SAPI) Tag: 236127
  - 24
    - filetostr() /strtofile() capacities I have to make multiple copies of some files in the size range of 2000 to 7000 kb and it seems like it'd be more efficient to do a single filetostr() followed by multiple strtofile()'s --rather than multiple copy's - I'm using winapi CopyFile()-- but I have no clue as to how this would affect system performance. The pc in question has 2g ram. Can anyone share their experience with this sort of thing? -Lew Tag: Converting VB code to VFP (Using SAPI) Tag: 236126
  - 25
    - table names from a query Hi I have 2 like querys. The only difference is one picks the .T. , the other picks the .F. Here is the code behind the query; SELECT Reservefile.pbfrsvcd1, SUM(Reservefile.wrvrsvamt),; Reservefile.pbfcd, COUNT(Reservefile.pbfrsvcd1),; SUM(Reservefile.pbfprm), SUM(Reservefile.pbfprmannl),; SUM(Reservefile.pbfamt), SUM(Reservefile.wrvprmdefg),; SUM(Reservefile.wrvprmdefn), SUM(Reservefile.wrvprmuneg),; Reservefile.wrvyr1flag, Reservefile.wrvprmcd, Reservefile.pmdtype,; SUM(Reservefile.wrvprmunen); FROM ; reservefile; WHERE Reservefile.wrvyr1flag = ( .T. ); GROUP BY Reservefile.wrvyr1flag, Reservefile.pbfrsvcd1; ORDER BY Reservefile.pbfcd, Reservefile.pbfrsvcd1; INTO TABLE 1styear.dbf This query names the table A or B or C Then expect to find that file later. The second query SELECT Reservefile.pbfrsvcd1, SUM(Reservefile.wrvrsvamt),; Reservefile.pbfcd, COUNT(Reservefile.pbfrsvcd1),; SUM(Reservefile.pbfprm), SUM(Reservefile.pbfprmannl),; SUM(Reservefile.pbfamt), SUM(Reservefile.wrvprmdefg),; SUM(Reservefile.wrvprmdefn), SUM(Reservefile.wrvprmuneg),; Reservefile.wrvyr1flag, Reservefile.wrvprmcd; FROM ; reservefile; WHERE Reservefile.wrvyr1flag = ( .F. ); GROUP BY Reservefile.wrvyr1flag, Reservefile.pbfrsvcd1; ORDER BY Reservefile.pbfcd, Reservefile.pbfrsvcd1; INTO TABLE renewal.dbf This one names the table renewal.dbf ---as I want. I do not want aliass thanks sherry Tag: Converting VB code to VFP (Using SAPI) Tag: 236120

This is an SAPi5.1 utility called TexttoSPeech made in VB.

VB can open files as binaries and the convert it to unicode to displayed in
an editbox which can show characters of any language

The code is this:

Open ComDlg.FileName For Binary Access Read As 1
MainTxtBox.Text = StrConv(InputB$(LOF(1), 1), vbUnicode)
Close #1

I could find equivalents for VFP. STRCONV function offer some of this but
the equivalent function in VB is different. I could not display chinese
words in an edit box.

Had someone done something similar?

Thanks.

Alejandro Fernandez

Top