Any last requests?

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
    - Making a calling form invisible I have developed an Output class to handle reporting, exporting etc. This is called from scores of forms with a few parameters. After it has all been designed I have decided that I would like to make invisible whatever form calls the Output form. I can do this by: thisform.visible = .F. DO FORM <outputform> thisform.visible = .T. but I would like to avoid having to edit so many forms. Is there a way I can achieve this from the Output class without having to edit all these calling forms. I am NOT passing the calling form as an object parameter to the class. I wish now that I was! Thanks Stephen Tag: Any last requests? Tag: 231475
  - 2
    - What's in the 71st byte of FXP files? We're using an utility who checks differences between FXP from different releases of a VFP software, and it uses a simple file compare logic. We cannot base that on "data and time modified" because these are unreliable, expecially after another utility recompiles all of the files. This morning we started noticing that the comparison found differences in all of the FXP even if we modified only a few, and the reason is that the 71st byte is always different from the past releases. It looks like something has changed in the output of the "compile xxx nodebug" command, starting from yesterday or today. Has anyone else had an issue as this? What could have triggered this situation? And, BTW, who knows where I can find info on the FXP file structure, of about the 71st byte of FXP's? -- Microsoft News Tag: Any last requests? Tag: 231474
  - 3
    - Combine aggregate records from a UNION? Say I have 2 tables of invoices, one containing 2006 invoices and the other 2007. In a single SQL statement, I want to sum up the invoice amounts, grouped by customer number: SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2006 GROUP BY CustNo UNION ALL SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2007 GROUP BY CustNo INTO CURSOR Tmp ORDER BY CustNo If a given CustNo exists in both Inv2006 and Inv2007, the UNION will produce 2 records for this CustNo: one with the total amount for 2006 - the other the total for 2007. How can I modify my SQL statement to consolidate the results of the UNION so that I only end up with ONE record for the CustNo - with InvTotal equal to the total customer spent in 2006 plus 2007? Many thanks! -Mike Tag: Any last requests? Tag: 231461
  - 4
    - missing subreport? ireponame = 'REPT_360.rpt' isubreponame = 'subtotal' SetCrRpt(thisform.olecontrol1) with Thisform.olecontrol1 .reportfilename = ireponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = isubreponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = '' .destination = outputtype .printreport() endwith I found that there is no "subreport.rpt", only a "rept_360.rpt". Is this sub-report a fake? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Any last requests? Tag: 231459
  - 5
    - Tableupdate failure-index does not match..... I have a parameterized view. I put a few records in it. I update the records. I issue tableupdate. If I don't update the first record in the view, the tableupdate fails, and aerror() shows me Index does not match the table..., error 114. I know for a fact that there is nothing wrong with the index, and this only happens if I don't enter a value in the first record. I've seen this before, but don't remember where or when. Anyone recognize this issue? Tag: Any last requests? Tag: 231456
  - 6
    - Customzied papersize setting Hi all, I have defined a new label size for printing labels using barcode printer. It works fine in my pc when running my foxpro program. However, when it is printed from the others pc, the label size gets the other size although new label size is already set. I have tested many times by setting the default printer which refered to the new label size. It still failed. Finally, I discovered that it's the problem of papersize. My PC papersize for the new label is 134 and it works in my pc but not on the others. However, I have set the papersize to 154 and it doesn't work on my pc, but it works on one of my colleagues pc. Is there any default papersize setting that refer to customized size on window XP ? Thanks a lot! -- sze Tag: Any last requests? Tag: 231455
  - 7
    - Disable Menu Items Hi, How do I disable Menu Items (Using Define Menu) when I preview a report? Thanks, Herbert Tag: Any last requests? Tag: 231453
  - 8
    - How to get the form object ? Dear All, How to get the "Form Name or Form Object" in object "ytxt" ? e.g. ytxt = thisform.pgf1.page1.pgf2.page3.txtbox Thanks ! Tag: Any last requests? Tag: 231441
  - 9
    - test -- Thanks ! Tag: Any last requests? Tag: 231440
  - 10
    - Import UTF-8 text from Excel Is it possible to import or read texts from an Excel file that include = UTF-8 texts? Robert Tag: Any last requests? Tag: 231435
  - 11
    - Intermittent Error 12 - Variable Not Found I have a situation where I am intermittently getting Error 12's trapped to my application (VFP7 based). The code path is something like the following: In my form: snparptr = 0 =gnssadd(,,,,) In gnssadd the following code is executed: =gnaddrec() REPLACE fddate WITH DATE(), ; fcsnaptime WITH TIME(), ; fnparent WITH snparptr, ; fccancel WITH vccancel, ; fctable WITH lctable, ; fcaction WITH vcaction, ; fnrecno WITH lnrecno, ; fcprompt WITH vcprompt SAVE TO MEMO fmdata ALL LIKE f* The gnaddrec either adds a new record to a table or reuses a deleted record. The error 12 error nominates the snparptr as the variable that is not found I cannot see a code path were the snparptr variable is disposed of. The problem is very intermittent and in most cases once the error has been received you can re-enter the program and execute the same function and have it work fine. Is there some resource that is being depleted that is causing this error? or any suggestions of another cause? thanks pete Tag: Any last requests? Tag: 231428
  - 12
    - eReports on vfp6 untracable error Using DBX tech eReports, we have a report to pdf conversion that works fine in the IDE and locally compiled but returns a code 124 on a clients system running under terminal services. the oReports.ErrorLog seems not to be returning a string any help to resolve this would be appreciated John Tag: Any last requests? Tag: 231426
  - 13
    - do work intellisense , form , with , endWith This is a multi-part message in MIME format. ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all i would like to have intellisense for my form, With the operator With = EndWith i would like to have my custom Method or Custom Property. With ThisForm as Form of G_RUE.SCX EndWith it's doesn't work , have you an idea ? thank's=20 Olivier ------=_NextPart_000_00B0_01C76FB5.AC335F00 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.3059" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>Hi = all</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 = size=3D2></FONT></STRONG> </DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have=20 intellisense for my form, With the operator With = EndWith</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have my=20 custom Method or Custom Property.</FONT></STRONG></DIV> <DIV> <DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2><BR>With = ThisForm as Form of=20 </FONT><FONT face=3D"Courier New" size=3D2>G_RUE.SCX</FONT></DIV> <DIV> <P><FONT face=3D"Courier New" size=3D2>EndWith</FONT></P> <P><FONT face=3D"Courier New" size=3D2><STRONG><FONT face=3DArial = color=3D#000080>it's=20 doesn't work , have you an idea ?<BR><BR>thank's=20 <BR></FONT></STRONG></FONT><STRONG><FONT face=3DArial color=3D#000080=20 size=3D2>Olivier</FONT><FONT=20 face=3D"Courier New"></P></FONT></STRONG></DIV></DIV></BODY></HTML> ------=_NextPart_000_00B0_01C76FB5.AC335F00-- Tag: Any last requests? Tag: 231416
  - 14
    - vfp9 speed issue group, our app has several screens with hundreds of objects. They open instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9 totally useless for us. Has anyone come across this type of behavior? We use vfp9sp1. Wade Tag: Any last requests? Tag: 231410
  - 15
    - Active Directory User name and Password How can I read the user name and password from Active Directory? in other words how can I authenticate a user through Active Directory? Thanks HME Tag: Any last requests? Tag: 231406
  - 16
    - print dbf file How do i print dbf file Tag: Any last requests? Tag: 231382
  - 17
    - Which Tags Are Used? Hello and thanks for the help. Is there any data in the CDX file that would indicate that last time an index tag was used? I have a table with a lot of tags some of which I sure are never used. I can search the code but that doesn't tell me which ones might have been created to speed up an SQL query. Is there any index tag usage data available? Thanks, Jeff Tag: Any last requests? Tag: 231367
  - 18
    - Fox Programmer .... Need Jobs Sir, My name is Tommy from Thailand. With my Visual FoxPro experience more than 6 years. I need more jobs. Who have jobs for me, feel free to contact me anytime Thanks Tag: Any last requests? Tag: 231366
  - 19
    - Check to see if SQL table has been updated by another user Hi... What's the quickest and simplest way to check if a row has been changed (by another user) on a remote SQL table? Obviously TABLEUPDATE returns .F. if it encounters and error but it would be better to 'test' the condition before even attempting to perform the update. Any help would be much appreciated. Tag: Any last requests? Tag: 231364
  - 20
    - buffering select 0 use tablea shared select tablea cursorsetprop("buffering",4) set filter to type="A" select use tablea again shared alias tableb set filter to type="B" * 1. is the following necessary? select tableb cursorsetprop("buffering",4) ... ... show form to edit these values ... ... * 2. if I tableupdate() tablea, * will tableb be tableupdated() as well? 3. Any other things I need to remember? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Any last requests? Tag: 231355
  - 21
    - help, cash denomination.... hi experts, anybody can give me some example that of cash denomination, like for example, the given is 1525.75 and the output would be.... 1000 - 1 500 - 1 100 - 0 50 - 1 20 - 1 5 - 1 .50 - 1 .25 - 1 thanks in advance.... Tag: Any last requests? Tag: 231353
  - 22
    - Vista and Elevation Hello all! I have been working for 2 days trying to figure out how to change my application (written in VFP9) to work with Vista. The first objective is writting to the registry. The way our application works... the first time you launch it, it asks for a Code. The user enters this code and the program saves it to the registry under HKEY_LOCAL_MACHINE. This works great under XP. This way if they change users or they are running terminal server, they all find this entry in the same location. In order to write to the HKEY_LOCAL_MACHINE on Vista, you must be elevated to Administrative level. I have read several articles on how to achieve this, but the common belief is to create a separate program that can be run from your main program. This new "separate" program should be setup to require administrative rights using a manifest file. Now the trick I needed to pull off was to be able to call this program and wait for it to close. I tried a few solutions... but the one that seemed to work best for me was to create a third program. This third program will be a COM Object accessable by Foxpro, with the sole purpose of running the "separate" program mentioned above and wait for it to close. I call the COM Object from VFP and it stops the VFP programs execution until the separate program is closed. Perfect! It seems like I found the answer.. but because I knew it had to be too good to be true I decided to test a little. I created two shortcuts on my Vista desktop. Both shortcuts run Foxpro 9, but one is flagged as "Run as Administrator" and labeled "Admin". The other shortcut runs as Standard User is titled "Standard". When I run the Standard VFP shortcut and execute the Com Object, everything is perfect. Life if great! Now I tried to run the VFP shortcut "Admin" and access the COM Object. Here is where the problem is..... Class definition x.y is not found Help! I don't know what to do next. When I run the "Admin" shortcut, Vista prompts be to "Allow / Cancel". It is elevating my instance of VFP to Admin level. But when I attempt to execute the COM Object it cannot find the class definition. Any ideas on how to get around this "little" problem? How is everyone else handling this? Thanks Dan Tallent Tag: Any last requests? Tag: 231330
  - 23
    - Gefile on terminal server Hi, a client reports following situation with our Application (built on VFP9SP1): Every dialogue, where we use the putfile or the getfile function, does not appear. They had to delete the local profiles of the user on the server, because there were problems in the encryption module, and after that, the getfile() - function does not show the input form. the command is totally ignored... How can I make the dialogue appear? Thank you! Bastien Tag: Any last requests? Tag: 231316
  - 24
    - Winsock and ip address changes Hi and thanks in advance for the help. This isn't strictly a Fox question but since I develop in Fox I thought I'd see if any of you have any ideas about this. I use the MS WinSock control. One of the properties is LocalIP which should be your machine's IP address. It is set by the control and not changeable in code. My application stopped working and I was looking at the LocalIP property. It said 0.1.4.0 instead of 192.168.0.33 which is my correct ip address (fixed, no dhcp involved) Once I rebooted, the LocalIP went back to 192.168.0.33 I'm curious as to how it got changed. Did I have some poorly behaved software? Did my machine need a re-boot and the funny IP Address was a symptom? Is something more evil going on? If anybody knows anything about this please tell me. Thanks, Jeff Tag: Any last requests? Tag: 231310
  - 25
    - Upgrade from VFP 6 to 9 - RUN command fails I have the RUN command in a long-standing app that I am now running under VFP 9 for the first time, but even from the command window, a simple RUN cmd or RUN command both fail. I'd appreciate suggestions on what to look into next. The RUN command is an integral part of this application and we need it to work. If I do a DIR <batchfilename> from within VFP 9, the file is there, and I can edit it from a cmd window (which I just did) and save my changes, and I also just ran it from a cmd window, but this is a cmd window opened by the operating system (me clicking on the shortcut on my desktop labeled "dos box") and not from within VFP 9. Thanks in advance. -S- Tag: Any last requests? Tag: 231308
- Next
  - 1
    - Problem with VFP9 report In group footer we have: in 1st line - field object with Fix relative to top option in 2nd line - field object attached to memo field in table with Fix relative to top and Stretch with overflow options in 3rd line - field object with Float option in 4th line - field object with Float option If memo field has up to 20 lines everything is ok, but if memo filed is longer than 20 lines footer continues on next page but it does not print 3rd and 4th line. Thanks in advance Tag: Any last requests? Tag: 231298
  - 2
    - FoxPro with MySQL how to use Foxpro to access MySQL database ? some sample will be good. thanks! Tag: Any last requests? Tag: 231297
  - 3
    - List of all Foxpro base properties? I am trying to write a program to document the custom classes I made. How could I obtain a full list of base property names of all base classes, so that I could auto-magically know the property is a custom one or a base one? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Any last requests? Tag: 231293
  - 4
    - Patches for VFP 9.0 I just installed VFP 9. On this page: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx The first item is SP1, and the second item says what's in it is already in SP1. What about the remaining items on the page - do I want/need them? XSource FFC VFPCOM Utility There is a brief explanation of each on the web page but I'm afraid it's a little too brief for me. TIA. -S- Tag: Any last requests? Tag: 231291
  - 5
    - Delete query Can someone tell me why the following does not work? I have two tables, cps and complete. I need to delete all the records in cps that match the records in complete. Here's my query: DELETE FROM cps.DBF WHERE Cps.invoice = Complete.invoice When I run that above Foxpro tells me that 0 records were deleted. Any help would be greatly appriciated. Jim Tag: Any last requests? Tag: 231286
  - 6
    - Sending report to file I have a large VFP application I inherited. There is a function I made to create a PDF from a report and email the PDF file. I send the output to a file using the command REPORT FORM MyReport NOCONSOLE TO FILE MyResultFile.ps I then use GhostScript to create a PDF. Everything works fine the FIRST time, but the next time I run the REPORT FORM command, the output is sent to the default printer and not a file. In trying to find the problem, I have used DISPLAY MEMORY TO FILE both times to compare the contents of memory. I have done the same with DISPLAY STATUS. I do not see any glaring differences that would prevent the output to a file the second time around. If I exit the application and reenter each time, the report is sent to a file successfully. It only fails if I _don't_ exit the application and it only fails after the first run. I have verified the printer is being set correctly and the SET('PRINTER', 3) is the printer with the postscript driver. This definitely seems like a bug in VFP since a file is not created and the REPORT FORM command should produce a file because of the "TO FILE". Any ideas? Tag: Any last requests? Tag: 231285
  - 7
    - Question: Is VFP a Developing tool or a Database ? If you believe so, please take a look at the following link which is there since 2004: http://www.microsoft.com/usability/enrollment.htm Demetrios, Greece Tag: Any last requests? Tag: 231278
  - 8
    - Project Documentation Machine What is "repair object hierarchy in progress"? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Any last requests? Tag: 231271
  - 9
    - VFP9: Weird Event Issue A central part of my app is the Invoicing Wizard. It gives the operator a display of Work Orders and the opportunity to select one for invoicing. Because of the nature of the business, there are many things to check before invoicing, so the form has thirty-two buttons. While this might seem to be a good entry for the Interface Hall of Shame, it does work rather well. (Yes, I have used the app as well as having written it.) There is a peculiar behaviour that I noted when working on a related matter. Each Work Order listed has a textbox next to its details. Putting a "Y" in it selects the Work Order for invoicing. The textbox has input validation for whether it will allow the Work Order to be selected for invoicing. Among the things that is checked is the Work Order Type. If it is "E", then a messagebox asks whether this is what was really intended and should the system change the type to "F". If yes is chosen, the Work Order is updated and so is the display. If not, the Work Order is not selected. If "Y" is entered into the textbox, focus is moved off it (say, with <Tab>), and then the "Generate Invoice" button is clicked, invoicing will start. However, if "Y" is entered into the textbox, but focus is not first moved off the textbox before clicking "Generate Invoice", when the Work Order Type is "E", the messagebox will appear, a yes response will result in the Work Order and the display being updated, BUT invoice generation will not start. The focus will be on the Generate Invoice button, but the button's click will not get executed. My question is why does the button's click not get executed. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Any last requests? Tag: 231262
  - 10
    - SQL query problem with character comparison. Hi, I have a problem in Foxpro. We have a query like Select * from Account, Bank where alltrim(account.bank_id) = alltrim(bank_bank_id) and alltrim(account.Bac) = alltrim(Bank.Bac) and alltrim(Bank.Bac) = '0000991' and not Deleted() Bank table has a column Bac which is type Charater(7). The application always inserts 7 charactes in this column. Eg. for 71 it will insert 0000071. But i have some records in the table which are marked deleted and they have bac column as 0001 i.e is less than 7 characters. The problem is above query does not return a result set even though there are records present. Moreover if i pack the table Bac, the query works fine. I also tried changing the query to Bank.Bac = '0000144'. Initially it worked fine and returned me 400 records. Then i zapped 300 records from account and executed the query. this time it agan gave me no records. By some trial and error i found that the modified query worked if there were more than 170 records. For any less it gave blank recordset. I want to find out the reason for such weird behaviour and if this some Foxpro limitation Please reply. Thank you Tag: Any last requests? Tag: 231250
  - 11
    - Foxpro going open-sourced? http://www.linux.org/news/2007/03/20/0001.html -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Any last requests? Tag: 231249
  - 12
    - Mulitiselect records on the Grid hi expert, how can i multiselect records on the grid. can you give me some example code thanks.... gechelle Tag: Any last requests? Tag: 231243
  - 13
    - Microsoft is going open-source the core portions of the Visual FoxPro DBMS! I want to be between the first ones to bring this news: http://www.eweek.com/article2/0,1759,2105307,00.asp =A1Can't believe that! Best regards, Fernando D. Bozzo Tag: Any last requests? Tag: 231239
  - 14
    - focus.fll and vfp9 I used focus.fll in my vfp7 application, and there are hundreds of users out there. I used 2 functions (fil_encrypt and fil_decrypt) to encrypt and decrypt personal information. (I also used fil_open and fil_create but haven't started to worry about these yet). I am in the process of moving this application to vfp9 and of course focus.fll is no more. My dilemma is how to enable users to transfer their data. I don't really want to have to supply a separate vfp7 exe with runtimes to convert the data, but can't get a response from fastwrite.com about purchasing the source code for these functions. Does anybody have any help or advice to offer? Sincerely Stephen Ibbs Tag: Any last requests? Tag: 231232
  - 15
    - Foxpro 2.6a windows Install disks Anyone know how I can get access to install disks for this program? Does anyone that no longer needs their copy be willing to sell it off to me? Tag: Any last requests? Tag: 231224
  - 16
    - No more Foxpro Would Micro$oft open the source codes of VFP since it's only Micro$oft that has no interest in it..... -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.20.3 ^ ^ 20:18:01 up 1 day 6:36 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Any last requests? Tag: 231222
  - 17
    - How to APPEND FROM XLS for Cell with formula? Good day everybody, I am using VFP8.0 and Excel 2002. I have been using VFP program to use APPEND FROM to read Excel file and fill my DBF with data. So far I have no problem with that. However due to end-user request to minimize data entry work, I replace one of the Excel column with formula VLOOKUP to get some data from Excel table in the same workbook. Now I couldn't get the result upload into DBF file. I get a black box and first letter of the result only. I will appreciate if some one can guide me to solve the problem. Thanks in advance and hope to hear from you. Best regards, Julie Tag: Any last requests? Tag: 231218
  - 18
    - Variable declaration doubt why and what is the benefit of following code local oSomething as "SomeServer" over the following code local oSomething since following code works even without declaring the variable. oSomething = NEWOBJECT("SomeServer") thanks! Tag: Any last requests? Tag: 231212
  - 19
    - [fw] can this routine be sped up? wait wind "Starting Excel..." nowait tmpsheet = getobject('','excel.sheet') XLApp = tmpsheet.application XLApp.WorkBooks.Add() XLSheet = XLApp.ActiveSheet t_head1 = 1 select output goto top t_loop = 1 do while !eof() t_loop = t_loop + 1 XLSheet.Cells(t_head1+t_loop,1).Value = "'"+bookno XLSheet.Cells(t_head1+t_loop,3).Value = "'"+bookname XLSheet.Cells(t_head1+t_loop,4).Value = 'BOOK' XLSheet.Cells(t_head1+t_loop,5).Value = "'"+iif(empty(output.oapprm1),'',left(dtoc(output.oapprm1),5)) XLSheet.Cells(t_head1+t_loop,6).Value = "'"+iif(empty(output.ppdate1),'',left(dtoc(output.ppdate1),5)) XLSheet.Cells(t_head1+t_loop,8).Value = "'"+iif(empty(output.pstarts1),'',left(dtoc(output.pstarts1),5)) XLSheet.Cells(t_head1+t_loop,9).Value = "'"+iif(empty(output.bstarts1),'',left(dtoc(output.bstarts1),5)) XLSheet.Cells(t_head1+t_loop,10).Value = "'"+iif(empty(output.bcd1),'',left(dtoc(output.bcd1),5)) skip enddo -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Any last requests? Tag: 231206
  - 20
    - How to "select ..." on SQL Server 2000, Thnaks! Dear All, How to "select ... " on SQL Server 2000, Thanks! Q1: "select recno() as yrecno, * from tablename into cursor xx order by 1" Thanks! Tag: Any last requests? Tag: 231199
  - 21
    - Grids In VFP6. Can you create a grid programmatically ? I can create a window on the fly and activate it, but would also like to put a grid into it with selected characteristics Thanks.. -- Tim Hobson Tag: Any last requests? Tag: 231190
  - 22
    - Docking Windows Hi, When docking a window on the side and another on the bottom, the bottom window will always push the side window up. It seems when docking on the top or bottom, those windows will always dock full screen width. Is there anyway to change this so the windows docked on the side will show full screen height? Thanks Dave Tag: Any last requests? Tag: 231185
  - 23
    - VFP9: How to prevent undocking of a form? Hello How to prevent undocking of a form? Thx Tag: Any last requests? Tag: 231183
  - 24
    - sql question reference name continue 1 apple 1 2 apple 2 3 apple 3 4 boy 1 5 boy 2 6 cat 1 7 cat 2 8 cat 3 9 cat 4 10 cat 5 11 apple 1 12 apple 2 13 boy 1 How to produce "continue" from the first 2 columns? -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.10) Linux 2.6.20.3 ^ ^ 15:22:01 up 1:40 0 users load average: 1.00 1.01 1.01 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: Any last requests? Tag: 231177
  - 25
    - No VFP At the risk of seeming utterly self-concerned, I was wondering what the easiest path might be for VFP programmers. I don't think I can in good conscience start a new project in VFP. Does anyone know what languages and developer interfaces are similar? I hope Microsoft gives us some guidance. It seems as though they should drop Access and keep VFP. I started with dBase II, went on to DBXL, then finally Fox. This whole thing is very sad news because I love Fox. I'd love to hear from others. Monique. Tag: Any last requests? Tag: 231171

I could work with VFP for a while more if only I could read and write =
UTF-8 in Sql Server without double byte translations leading to ??? =
(unless somebody knows how to do this with the current VFP)

What are other requests that people would still have?

Robert

Re: Any last requests? by Anders

Anders
Wed Mar 28 17:06:34 CDT 2007

Are you sure? From Books On Line:
"SQL Server stores Unicode in the UCS-2 encoding scheme. However, many
clients process Unicode in another encoding scheme, generally UTF-8."

-Anders

"RobertVanGeel" <robert@bign.nl> wrote in message
news:OuQa6WXcHHA.4872@TK2MSFTNGP03.phx.gbl...
I could work with VFP for a while more if only I could read and write UTF-8
in Sql Server without double byte translations leading to ??? (unless
somebody knows how to do this with the current VFP)

What are other requests that people would still have?

Robert

Re: Any last requests? by Anders

Anders
Wed Mar 28 17:20:23 CDT 2007

Will SYS(987) help?
To input ANSI into SQL Server for conversion to Unicode there the N' prefix
for strings.

-Anders

"RobertVanGeel" <robert@bign.nl> wrote in message
news:OuQa6WXcHHA.4872@TK2MSFTNGP03.phx.gbl...
I could work with VFP for a while more if only I could read and write UTF-8
in Sql Server without double byte translations leading to ??? (unless
somebody knows how to do this with the current VFP)

What are other requests that people would still have?

Robert

Re: Any last requests? by RobertVanGeel

RobertVanGeel
Thu Mar 29 01:23:00 CDT 2007

Briljant! Thanks!!!

Robert

"Anders Altberg" <anders.altberg> wrote in message =
news:ed6ANdYcHHA.1216@TK2MSFTNGP03.phx.gbl...
> Will SYS(987) help?
> To input ANSI into SQL Server for conversion to Unicode there the N' =
prefix=20
> for strings.
>=20
> -Anders
>=20
> "RobertVanGeel" <robert@bign.nl> wrote in message
> news:OuQa6WXcHHA.4872@TK2MSFTNGP03.phx.gbl...
> I could work with VFP for a while more if only I could read and write =
UTF-8
> in Sql Server without double byte translations leading to ??? (unless
> somebody knows how to do this with the current VFP)
>=20
> What are other requests that people would still have?
>=20
> Robert
>=20
>=20
>