Store Japanese characters from FoxPro into SQL Server?

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
    - Pack causing intermittant fatal error VFP7 SP1 I originally posted a message about this problem on 12th May. I am beginning to think it may be a problem with the user's PC. As the crash happens during a pack and the file has actually disappeared from it's original place, the fatal error must be happening at the point where VFP deletes the original table from disk and renames the temporary table with the original table name. Where on the user's machine would this temporary table be located? We do not use any Config file. Is it the Windows temporary directory? Could there be a problem with that user's windows temporary directory or permissions to that directory? Note - the file that is being packed is not particularly big. Any help would be appreciated. Bernie. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197810
  - 2
    - Visual SourceSafe with VFP8 I stopped using VSS a long time ago (found it presented many errors) when I was using VFP6. I didn't have time to sort all of the issues out back then. Now I am up to VFP8 and would like to get back to using some sort of CVS system. Will the version of VSS (6?) that I got with Visual Studio 6 work with VFP8 or should I be looking at an alternative CVS system? Perhaps a newer version of VSS. Ideally if an alternative one I would like it to be freeware. But then who wouldn't. -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197808
  - 3
    - FPW2.6a SCAN FOR missing records Hello, this is driving me crazy :( I have a screen that lets the user add/remove multiple items to an assembly. The items are stored in an array whilst they edit and then stored in the main table if they save. The save routine looks like this: SELECT pri_det m.arrayref=1 m.arraylen=ALEN(priceinf,1) SCAN FOR wk_ref = m.ref IF m.arrayref<=m.arraylen * already existing record - replace contents REPLACE pri_det.saparticle WITH RIGHT(priceinf[m.arrayref],6) m.arrayref=m.arrayref+1 ELSE * array has fewer records than table - delete record DELETE ENDIF ENDSCAN * add any remaining records from array to table DO WHILE m.arraylen>=m.arrayref INSERT INTO pri_det VALUES (m.ref,RIGHT(priceinf[m.arrayref],6)) m.arrayref=m.arrayref+1 ENDDO Sometimes when they remove items, this doesn't work correctly and the SCAN..ENDSCAN doesn't loop all the records in its FOR clause. Does anyone know WHY!?!! 1) There is no filter set. 2) I've recreated the indexes with INDEX ON. (although I haven't tried a SCAN.. NOOPTIMIZE yet) 3) I've pulled that routine out into a separate program (working on the same table) to try to reproduce and it seems to work fine. 4) I wrote a little program that SCANS the same clause just doing an incremental count to a vraible and then display the result in a wait window. I used my screen to remove some items and broke the save routine just before the SCAN. At this point I ran my counting program - it showed a SCAN FOR wk_ref=m.ref count of 5 records. When then went on to single step the save routine it only SCANned 3. What on earth could possibly be wrong here? -- TIA Andrew Howell Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197805
  - 4
    - How to print image file from VFP report? Hi all, I have some problem about VFP7 report. I want to use report to print the image that I have scan from the document in tif type but the report ole image can use only bmp and jpg.Is the vfp7 report can use only this two type? And when I use BMP file which greater than 1 meg the report can not run, it is error. How can I do? Thank you for your advise. Kitty Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197804
  - 5
    - Saving Picture in SQL Server Hi there, I need to know how can i save picutre in SQL Server table. I am using VFP 6.0 as front end and SQL Server at back end. I have already tried FILETOSTR() AND STRTOFILE() Function which performs well with Foxpro table but it does not work with SQL Statement as follow; tmpString=FILETOSTR("Picture.Bmp") =SQLExec(connHandler,"Insert Into temp (EmpPhoto) Values ('"+tmpString+"')") It looks String already contains some single quotes which creats ambiguity. Would be very thankful for any help in this regard. NR Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197803
  - 6
    - Coordinated grids and a lookup textbox I have 3 grids on a form, a parent(name) & 2 children (phones & emails). I have the grids set up so that as the user scrolls through the parent grid, the other 2 grids update themselves appropriately. Now I'm adding a textbox to serve as a quick look up for names in the parent grid. I do a locate for .../ if found(), etc... in the interactive change of the textbox and the parent grid updates itself correctly. Unfortunately, not only do the child grids NOT update correctly, they no longer track the parent grid if the user goes back to the parent & begins scrolling again. Calling the respective refresh methods doesn't seem to work. What to do? Any ideas? -Lew Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197802
  - 7
    - Check Box in VFOXPRO Always shows that it is ReadOnly Hello, I am still new to VFoxpro and in need of some advice. I have a new form that I created and I have included some Check boxes. Whenever I RUN the form and try to click on the Checkbox, the message that I see at the bottom left hand side is "The control is Read-Only". How do I get my application/form to not display this message and allow me to click/unclick the checkbox? Thanks alot, Eddy. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197799
  - 8
    - Making CTRL+A Work in a Listbox Hi all. I would like to make CTRL+A work to select all items in a multi-select listbox. I've run into the problem that the CTRL+A combination won't register in a KeyPress() event of either a form or a control. I've come up with the following code that encapsulates a working solution within a listbox subclass as well as I can figure out. Of course, I'm aware of problems with using ON KEY LABEL and PUBLIC variables. If anyone can suggest a better way to do this, that would be very much appreciated. TIA, Ken Dibble Southern Tier Independence Center *** CTRL+A LISTBOX DEMO *** RELEASE ALL CLEAR ALL CLEAR LOCAL oldsafety oldsafety = SET("SAFETY") SET SAFETY OFF PUBLIC oForm oForm = CREATEOBJECT("Form") oForm.AddObject("Text1","Textbox") WITH oForm.Text1 .Top = 5 .Left = 5 .Height = 22 .Width = 100 .Visible = .T. ENDWITH oForm.AddObject("List1","MyListbox") WITH oForm.List1 .Top = 5 .Left = 120 .Visible = .T. ENDWITH oForm.Show(1) IF NOT EMPTY(oldsafety) SET SAFETY &oldsafety ENDIF RELEASE oForm DEFINE CLASS MyListbox AS ListBox RowSourceType = 1 RowSource = "ONE,TWO,THREE,FOUR,FIVE" ColumnCount = 1 ColumnWidths = "80" MultiSelect = .T. Height = 150 Width = 100 PROCEDURE Init ERASE handlectrla.prg ENDPROC PROCEDURE GotFocus THIS.Selected(1) = .T. THIS.SetupKeyHandler() ENDPROC PROCEDURE LostFocus THIS.ClearKeyHandler() ENDPROC PROCEDURE SetupKeyHandler LOCAL progstr TEXT TO progstr NOSHOW FUNCTION HandleCTRLA(oForm) IF UPPER(oForm.ActiveControl.BaseClass) == "LISTBOX" oForm.ActiveControl.SelectAllItems() ENDIF ENDFUNC ENDTEXT STRTOFILE(progstr,"handlectrla.prg",0) SET PROCEDURE TO handlectrla ADDITIVE PUBLIC oFormRef STORE THISFORM TO oFormRef ON KEY LABEL CTRL+A handlectrla(oFormRef) ENDPROC PROCEDURE ClearKeyHandler oFormRef = .NULL. RELEASE oFormRef ON KEY LABEL CTRL+A ERASE handlectrla.prg ENDPROC PROCEDURE SelectAllItems FOR x = 1 TO THIS.ListCount THIS.Selected(x) = .T. ENDFOR ENDPROC PROCEDURE Destroy THIS.ClearKeyHandler() ENDPROC ENDDEFINE *** END CODE *** Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197797
  - 9
    - error VFP 8 0: Class definition MSXML2.DOMDOCUMENT.4.0 is not found Hi, I had to uninstall VFP8 in order to reinstall VFP6 and then VFP8 again... however when I finished the Task pane Manager is showing this error message: 0: Class definition MSXML2.DOMDOCUMENT.4.0 is not found this was not happening the first time I installed VFP8 I already have tried to uninstall both VFP6 and VFP8, and installeng thean both agaon, but it did not fixed the problem, I also tried unsuccesfully "Repairing " VFP8 I would appreciate any suggestion thanks Oscar Taboada Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197783
  - 10
    - vfp 6.0 book Hi, I'm from the Philippines, the VFP6.0 Programmer's Reference book is no longer available in any book store here, is there anybody who could help me get a book of such? i've tried ordering throught the internet but all prospective agencies/couriers does not deliver in this country. from the last query that i made, they only deliver in Singapore. Pls help, i'm new in vfp OOP, i desperately need this book as reference. Thank you very much and more power. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197779
  - 11
    - Pocket PC and VFP Hi All, I have a new project, I want to control inventory using a Pocket PC. I don't have the time to learn a new programming language. Is there a way to program an application in Visual FoxPro and run it on a Pocket PC with Windows CE ?? If not is there another logical solution. Thanks in advance. Tanya Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197775
  - 12
    - keybd_event(, , , ) What would be the numbers for alt+ctrl+P? Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197773
  - 13
    - toolbar Using VFP 6, I use toolbar which is currently docked horizontally at the top LHS of the screen when forms are opened. I have two questions. 1. Because some buttons are inappropriate for some forms, the init for those forms calls a method in a class which makes those buttons visible property = .F.. In some cases, while this works OK otherwise, the toolbar is no longer horizontal but some buttons appear on a second line under others and I have to drag the toolbar manually to correct it. What causes this and how do I fix it ? 2. What I would really like is to have the toolbar docked centrally under each form which calls it. But as the forms are all different sizes this means that it needs to be in different places for different forms. Is there any way to achieve this ? Thanks -- Tim Hobson Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197764
  - 14
    - "Hidden" files attached to a form? Hi, I created an exe w/VFP8(SP1) and sent it to a friend. When he ran it, he got several messages re. missing files. The exe ran OK after choosing "Ignore" for each file. There was no problem in my testing because I have those files. Most of the "missing" files were temporary files (012345678.dbf, etc) but some were dbf's on my system that he doesn't have or need. From what I can tell, the error messages come up when DO FORM is encountered and before any of my code in the form executes. The trace shows that the program stops at DO FORM and before READ EVENTS. I suspect the files may have been open when I created the exe and somehow, VFP assumed they were needed. They are not needed and are not in the project. My exe uses only free tables and the default database (i.e. I never specified a database). I was able to fix this by deleting all the files that were being called. I also made a slight change to the form so that it would get re-generated when I re-built the exe. But that's only a stop-gap solution since it seems it could happen every time I build an exe and I have no way to know what files might be needed until I distribute the exe and get feedback from others. That's not a good thing. I've only been using VFP8 for a short time but I don't think I've ever seen this in VFP6. What can I do to prevent this from happening in the future? Thanks, Frank Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197759
  - 15
    - Alternative to upsizing wizard I have a VFP database that has some "unusual" features in indexes and views, like some IIF's, PADR's, UPPER's, etc., that the upsizing wizard doesn't know what to do with. Since I'm new to SQL Server, I don't know what to do with them either. Anyone have suggestions? Should I just simplify the VFP database? That would require some modifications to the application. -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - 2 0 0 4 at y a h 00 Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197756
  - 16
    - Automatically E-mail Reports I'm new to this group and need some help. I consider myself a novice when it comes to VFP. I'm looking for an easy way to modify our database to automatically E-mail packing lists to a static E-mail address at one of our sister companies. I'm finding this a challenge because there are no comments in the code and I was given no programmers documentation. I found a plugin called eReports that will do this, but I can't for the life of me follow their examples. I'd like to convert the report to .htm format then I'd like to send it out as an attachment without the user noticing. Before everyone starts yelling "post on eReports forum for help" I've already posted a message on their forum and haven't received response yet. I'm running Visual FoxPro 6.0 with Service Pack 3. Any help would be appreciated. ***** Here is the eReports snippet for converting to htm format ****** LOCAL lnResult, oHTML oHTML = NEWOBJECT("eReportsHTML", "eReports.dll", "eReports.dll") oHTML.ReportFile = "myReport.frx" lnResult = oHTML.ReportConvert() RELEASE oHTML ***** Here is the eReports snippet for SMTP ***** LOCAL loSMTP, lcRecipient, lcName, lnResult loSMTP = NEWOBJECT("eReportsSMTP","eReports.dll","eReports.dll") loSMTP.Unlock("Organization - E8FTY 4JR8S 2JX4R 49FJR") loSMTP.SMTPServer = "mail.johndoe.com" *-While not required, some SMTP servers need this. If you get -505 *-error, this is the likely solution. loSMTP.SMTPDomain = "johndoe.com" *-Optional loSMTP.SMTPLogFile = "c:\SMTPLog.txt" loSMTP.FromAddress = "support@johndoe.com" loSMTP.FromName = "Support" loSMTP.Subject = "Test" loSMTP.MessageBody = "This is a test" *-Alternatively Insert a message file between the quotes below *-The message file can be an exisiting boilerplate text/rtf file or an *-html file generated by eReports. *-If the message file is HTML, set the MessageFormat property to 1 or 2 (see help) *loSMTP.MessageFormat = && valid parameters are 0,1,2,3 (see help) *loSMTP.MessageFile = "" && "C:\eReports\Output\myreport.htm" *-The first parameter is the friendly name like "John Doe" or "" for empty *-The second parameter must be a valid email address *-The third parameter is the recipient type - 1=Normal, 2=CC, 3=BCC lcRecipient = "jdoe@johndoe.com" lcName = "John Doe" loSMTP.AddRecipient(lcName,lcRecipient,1) *-Include an optional attachment file by adding the file name between the quotes *-below or using a variable that points to an existing file. lnResult = loSMTP.AddAttachment((lcPDFFile)) lnResult = loSMTP.SendMail() IF lnResult = 0 MESSAGEBOX("Message Sent",0,"System Message") ELSE MESSAGEBOX("An Error occured:"+CHR(13)+loSMTP.ErrorLog,0,"System Message") ENDIF RELEASE oSMTP ***** This is the Exit command button code where the packing lists are printed in our database ***** if times=0 thisform.mybutton1.cmdnext.click endif private is_tally is_tally=0 thisform.label1.visible=.t. thisform.edton_hold.enabled=.f. thisform.command1.enabled=.f. thisform.refresh select exe_packinglist_0 replace on_hold_a with thisformset.form3.edton_hold.value if tableupdate(.t.)=.f. messagebox("Error in saving exe_packinglist_0.",0+16,"Error") tablerevert(.t.) else thisform.lockscreen=.t. scan thisformset.qtyorder_num=exe_packinglist_0.order_num_a thisformset.qtyseq=exe_packinglist_0.packing_seq =requery("exe_packinglist") select exe_packinglist replace on_hold with exe_packinglist_0.on_hold_a all if tableupdate(.t.)=.f. messagebox("Error saving exe_packinglist "+alltrim(Exe_packinglist.model_a)+".",0+16,"Error") tablerevert(.t.) endif select exe_packinglist_0 endscan thisform.lockscreen=.f. endif thisform.label1.visible=.f. thisform.edton_hold.enabled=.t. thisform.command1.enabled=.t. thisform.refresh select approval_pl scan thisformset.qtyorder_num=approval_pl.order_num thisformset.qtyseq=approval_pl.seq =requery("doc_pl") if _tally!=0 is_tally=1 report form doc_pl to printer noconsole endif endscan if _tally<>0 thisformset.form4.visible=.t. thisformset.form4.show thisform.enabled=.f. endif **************************************** Again, if anyone can point me in the right direction (or at least help me get started), I would appreciate it. Best regards, Tom Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197744
  - 17
    - global datasession It appears that even though Datasession 1 is called the "global data session" it is not actually global because when you are in another datasession you apparently can't access tables in datasession 1. Is that correct? Assuming it is correct, what would be the best way of having certain tables that you want to make available to all the forms in an application, even though these forms have private datasessions? The application I have is a school application that needs read access to student records from many different forms. I have standard procedures that have been opening up the student data files and reading from them when I need information, but the coverage profiler shows that this is a real performance killer. It would be much faster to have the tables open all the time for read access. I could simply open the tables when I start each form that needs access, but having a global instance of the tables would be quicker and more helpful. Kevin Clark Seton Home Study School Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197739
  - 18
    - Grids on form with Private Datasession and 3 tier application Please could someone give me a pointer in the right direction on this please. I am developing a small application but I would like to stick with the 3 tier architecture if possible. My forms are modeless with private datasessions. The problem is, I would like to display a recordset in a grid on my form. The grid control will only allow a table/cursor as a record source so I need some way to get that recordset through the tiers. I have tried creating a cursoradapter but the cursor gets created in the default datasession instead of the private one. I am on the verge of just coding the data access straight into my grid control but that would break the 3 tier design. Is my best option ADO or another idea? If I use ADO is there a grid that will accept ADO as a recordset or do I have to convert it back to a cursor? Your thoughts please. -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197737
  - 19
    - Conditional Counter field .. Want to add a Counter field to a Table which should be incremented only if certain field in the table is NOT EMPTY() ? How can I achieve this ? Urgent Response is urged. TIA Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197734
  - 20
    - VFP6 and Excel Hi I have a program in VFP6 that has OLE excel worksheet in a form I am able to print what I want by calling oXObj.PrintOut() but I can't get .PrintPreview to work. I would also like to be able to bring up the standard Print Dialog window can anyone help me with this. Any help greatly appreciated. Warren warrenjw@austarnet.com.au Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197729
  - 21
    - VFP6 & VFP8 on the same computer Hi, I have upgraded my computer from VFP6 to VFP8 for what i had to uninstall VFP6, however I have a framework (Visual Promatrix 6.0) that is sending error when I try to execute under VFP8.... is it possible to have both VFP versions installed concurrently on the same computer? how? thanks Oscar Taboada Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197728
  - 22
    - FPW2.6a changing browse title In FPW2.6, can I change the title of a browse window without releasing / redisplaying the browse? * something like this, but working ;) ***************************************** CREATE CURSOR test (test L) m.ltitle="text1" ON KEY LABEL f12 DO chgtitle BROWSE TITLE m.ltitle **************************** PROCEDURE chgtitle **************************** PRIVATE m.loldtitle m.loldtitle=m.ltitle m.ltitle="text2" SHOW WINDOW (m.loldtitle) REFRESH * also tried MODIFY WINDOW (m.loldtitle) TITLE (m.ltitle) *eof At the moment I'm doing this: ************************************* CREATE CURSOR test (test L) m.test="text1" m.looping=.T. ON KEY LABEL f12 DO chgtitle ON KEY LABEL esc DO killit DO WHILE m.looping BROWSE ; TITLE m.test ENDDO ON KEY LABEL esc ON KEY LABEL f12 ******************* PROCEDURE chgtitle ******************* PUSH KEY CLEAR RELEASE WINDOW (m.test) m.test=IIF(m.test="text1","text2","text1") POP KEY ******************* PROCEDURE killit ******************* PUSH KEY CLEAR m.looping=.F. RELEASE WINDOW (m.test) POP KEY *eof -- TIA Andrew Howell Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197721
  - 23
    - Create Label generates C0000005 error I have a VFP8 SP1 application (compiled EXE) that generates a C00000005 error whenever I run "MODIFY LABEL XXX" or "CREATE LABEL XXX" (xxx does or does not exist - makes no difference). I have another VFP8 SP1 application in the same directory (Command prompt emulator) that does not give C00000005 error. In both cases, no tables are open so it has nothing to do with data file corruption, indexes or a corrupt label file. Any ideas? Cheers David Younger Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197719
  - 24
    - Any real speed advantage with dual Xeon processors? Hi, I'm looking for the fastest performance I can get on a networked VFP app. The server which holds the data is currently dual Xeon, lots of RAM, Win 2003 Server, 15K SCSI drives, 10/100BaseTX LAN. My current idea is to upgrade the server to 1000BaseTX, and buy a dual Xeon workstation, plenty of RAM, 1000BaseTX, 15K SCSI drives and XP Pro. The app only needs to work on the one workstation, and the server is simultaneously handling data for 50+ other workstations with lower performance requirements. The data is all free table - I can't use DBCs/stored procedures because of FPD apps sharing the data. Do the dual processors make a difference to workstation speed with VFP? Does anyone have any better ideas? VFP7, but going VFP9 as soon as it's available. Regards, Neil Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197713
  - 25
    - How to get images to be added automatically to project I am trying to setup my app so that if I create a new project and add the startup routine, all necessary routines will be automatically added to the project. I do this by having a dummy routine that never gets called, that references all forms, classes, and reports. I also have a bunch of images I want added to the project that are not directly referenced. Any ideas how these could be referenced in a dummy routine so that the project will automatically add them on rebuild? Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197711
- Next
  - 1
    - PowerTCP UDP Control Does anyone have any experience using PowerTCP's UDP Control. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197699
  - 2
    - DBI-Tech ctTree Activex -- anyone know how to get node information Does anyone Know how to get node information such as text value when user clicks on a node from DBI-Tech ctTree activex control? ALso how do you know if the node you clicked on is a parent or child node? thanks Nick Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197687
  - 3
    - DBI-Tech ctTree activex -- how do I get node information? Does anyone Know how to get node information such as text value when user clicks on a node from DBI-Tech ctTree activex control? ALso how do you know if the node you clicked on is a parent or child node? thanks Nick Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197686
  - 4
    - Not enough memory message when joining source control project File -> Join source control project. This is a large project with several thousand files. VFP apparently does a get latest on the PJM file, builds a new PJX., and then does a get latest on everything in the PJX. When it finishes, I get "There is not enough memory to complete this operation". At the time this occurs, VFP is consuming 20MB physical memory, 10MB swap file, 209 GDI objects, and 2911 USER objects. This last entry concerns me, as 2911 USER objects is quite high and is probably why the error occurs. VFP will normally have less then 100. Historically, excessive USER or GDI usage is a result of poor programming, bugs, or memory leaks. I also think that this should work, even if it is using a lot of USER resources. Win2000/XP doesn't have the terminal USER or GDI limits that Win9x had, so I'm thinking that the problem here is internal to VFP. Also, it works for some of us, and not for others. It's not just my workstation, as I'm not the only one having this problem. Any ideas? Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197681
  - 5
    - VFP 9.0 beta help file I have downloaded and installed the beta of VFP 9.0. The help file does not function, and I wonder if this is the way the beta was released. Should I try downloading and installing again, or is this feaure just not working in the beta? -- seeker Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197678
  - 6
    - Watch for a fake bill Hi FP community, Make sure to watch out for a fake bill from Stonefield ... I guess they are desperate enough for business that they have resorted to sending a fake bill to try to get return customers. Very, very unethical business strategy in my opinion. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197672
  - 7
    - dbf and php there is an example to open with mysql and php a foxpro database? Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197663
  - 8
    - Tables with buffering VFP 80 Sp1 XP My form allows the user to add a record. (In this case to the zip code table). I control my "Save" and "Undo" according to certain rules. If the user enters a zip code that is already in the table, I want to prevent the "Save" from enabling. However, on the LostFocus of the textbox for the zip code, I will automatically save the record when I seek that code. How do I determine if that zip code codes not already exist? I could open the table twice, but that seems a waste. TIA Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197651
  - 9
    - _Screen.Image When an Image object is added to the _screen to show some picture or graphic and a user later runs a report in Preview mode, periodically the image object on the _screen, continues to show the report preview image even after the report preview has been released. It is as if the graphic image from the report preview window, overlays, changes or corrupts the PICTURE of the IMAGE object on the _screen. Has anyone else seen this behavior/bug, and if so, any ideas what causes it or how to fix it short of destroying the _screen.image object and re-adding it to _screen? Thx Alec Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197648
  - 10
    - Sql Server Question Assuming I have a table stored in SQL server. What is the best technique advised as to searching for a particular record since the Seek command can not be used. The two options that comes to my mind is the Locate and the set filter command. If the particular field I am searching for has been defined in SQL server as being an index key, how can one perform a search that would not be considered sequestial and move the record pointer to the record desired as in the seek command. Many thanks in advance. Shahriar Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197647
  - 11
    - displaying records through a preview window Hi, what and how would be the easiest way to display records in a pre-formatted preview window in vfp6.0? before with 2.6, i redirect the formatted report to a text file, viewing the result through 'modi comm (text output file)' and terminating the preview report throught the ESC button. With 6.0, i've heard of so many ways to implement it, i dont know now what to use as my standard program procedure? I'm thinking of using a 'Microsoft Word Document Viewer'. will this simplify my class creation and maintenance? Thank you very much and more power! Long live Foxpro! Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197646
  - 12
    - Cryptor IV fll file I can't seem to get a response from Xitech on the issue but they advertise the Cryptor IV is compatible with VFP 8 but there is not an fll for VFP8 included in my copy. Is there an fll for VFP8? And if so does anybody have it and can I get a copy. This should not be a problem as I can't use the fll without a legit copy of he rest and I have that and all. But it makes it a little hard to use the product in VFP8 without the fll since you have to have the proper version of the dll for each version of VFP that is supported. I have tried emailing Xitech on the issue several times and have not gotten any response from them at all. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197644
  - 13
    - dbf encrypting data Is there an easy and efficient way of encrypting data in dbf's? Looking for something simple.. thanks Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197636
  - 14
    - Adding events VFP80 SP1 on XP I have a basegrid in MyClass. I have added it to a form. When I run the form, I programmatically want to add a column and a Click() event to that column. I do not understand the Help screens on this issue. Anyone have a simple example. TIA Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197629
  - 15
    - set confirm and end of input ContainerA .textbox ContainerB 1. With SET CONFIRM OFF, how could I make a particular textbox on a form NOT to fire its valid()/lostfocus() event unless the user hit <enter>? 2. and when the user did hit <ENTER>, containerB will be made visible while containerA would be made invisible via containerA.textbox.lostfocus(). Any neat way to prevent containerA.textbox.valid() from being fired again when containerB was made visible? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:24am up 16:25 0 users 1.72 1.89 Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197628
  - 16
    - textbox focus (VFP6 unpatched) In one form, after going through a few events, a textbox.setfocus() was called, with textbox.format="K". Though the textbox got focus, the text inside was not selected (note the textbox.format) and sometimes, even the cursor is not inside the textbox, going somewhere. sometimes, the textbox, while in focus, didn't echo the text I inputted, though beneath the "surface", it's taking the input. The behaviour returned to normal after textbox.valid() fired once. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.26 ^ ^ 12:16am up 16:17 0 users 2.11 2.06 Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197627
  - 17
    - simulate PRINT-SCREEN I use VFP 8.0 I would like to simulate the print-screen (stamp) button Any ideas ???? thanks KEYBOARD '{ xxx }' Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197626
  - 18
    - Datagrid control for VFP 8? Does anyone have a recommendation on a grid control for foxpro outside of the Datagrid control that is shipped with VFP 8. Many thanks Shahriar Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197625
  - 19
    - cannot using "GROUP BY" clause hi why i can't include GROUP BY clause in my SQL-string ? thank Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197616
  - 20
    - Menu Creation I have created menu using menu command Everthing works fine through command window i.e. do program name. But, when i generate the EXE it does not work, Programme exits directly. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197610
  - 21
    - Complicated form with many search options Hello, I'm creating a form to manage serialized goods. The form shows data from 9 different tables. I also need to allow the user to search on a combination different parameters: Serial number Description GL Accounts Payment Due date Retail price Received Date AP Invoice # Categories They can search on as many or as few as they want. When faced with a form of this complexity, is it best to go with a CURSOR and update the records by hand, or is it best to use a view. The downside of the cursor is that it requires more work to commit the changes to the back end table. The advantage is that I have a lot more flexibility with my query statement. The downside of using a view is that I have to include all parameters in every search whether the user search on it or not. The advantage is that I can bind a view to the form itself and TABLEUPDATE() will handle the changes for me. Another problem is that a couple of my search fields are variable list matches that I make with a sub query against a temporary cursor and this might be difficult with a view (a variable table name parameter?) Does anybody have any tips on ways to go about this? Sincerely, Caleb Land Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197606
  - 22
    - NTFS system I need to know if our program is running on NTFS. I figure I could do this with OS(11). I am just checking if this is right. We only have NTFS stations so I can't see what a Win 98 will return with that function. I am guessing it will return a 0. Is this right? Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197592
  - 23
    - What am I missing in outer join query I am having problem with outer join in query. I am sure I am missing something and I am sure someone will point me the right direction. I have 2 tables AreaOffice Purchases I want all the records from Areaoffice and related purchases from Purchases table. AreaOffice: AOId AOName 1 AreaI 2 AreaII 3 AreaIII Purchases: AOId Date Amount 1 7/1/04 100 1 7/2/04 200 3 7/1/04 300 What I want is AOId AOName Date Amount 1 AreaI 7/1/04 100 1 AreaI 7/2/04 200 2 AreaII 3 AreaIII 7/1/04 300 But I dont get AreaII record on final result. Here is my query: SELECT AreaOffice.AoId, AreaOffice.AOName, Purchases.Date, Purchases.Amount ; from Areaoffice LEFT OUTER JOIN purchases on purchases.aoid = areaoffice.aoid ; order by ao_id Why am I not getting expected records? Thanks. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197591
  - 24
    - FormHandler only allows 1 form I have taken the following code from "Advanced Object Oriented Programming with Visual FoxPro 6.0" and if I'm not mistaken it only allows 1 form to be open at a time. Is this a bug? It should be easy enough to correct but I am just a little surprised. Function LaunchForm(tcClassName) *-- Check if we have to redimension the array If Alen(This.ApplicationForms,1)=1 AND NOT ; Vartype(This.ApplicationForms(1))="O" Dimension This.ApplicationForms(Alen(This.ApplicationForms,1)+1) EndIf *-- Create the form and show it This.ApplicationForms(Alen(This.ApplicationForms,1))=CreateObject(tcClassNam e) *-- Check form has been created If Vartype(This.ApplicationForms(Alen(This.ApplicationForms,1)))="O" *-- Form has been created *-- Show it This.ApplicationForms(Alen(This.ApplicationForms,1)).Show() *-- Return a reference to the new form Return This.ApplicationForms(Alen(This.ApplicationForms,1)) Else *-- Form was not created *-- Delete the reference from the array If Alen(This.ApplicationForms,1) = 1 *-- The array only had the one item so we can't shrink it *-- We can however clear the object reference This.ApplicationForms(1) = .NULL. Else *-- Shrink the array Dimension This.ApplicationForms(Alen(This.ApplicationForms,1)-1) EndIf Return .NULL. EndIf EndFunc -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.pegasus-opera-ii.co.uk Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197585
  - 25
    - callAll? I was wondering if anything like callAll for objects is being thought about for VFP 9. I havent found anything about it and after having setAll it seems to be the logical next step. CallAll should call the same method for all objects.. very similar to setAll just with methods.. I would like to get a suggestions about that to the developers of VFP.. I wonder if this is potentially the right place.. Tag: Store Japanese characters from FoxPro into SQL Server? Tag: 197576

Greetings!

I have an application that can happily store and retrieve Japanese
characters into a stand-alone FoxPro database. Now I need to write them
into nvarchar fields in SQL Server tables. SQL Server is expecting them in
Unicode.

I have an edit box into which I can enter Japanese characters through an
input method editor. I haven't been able to figure out how to massage those
characters to get them into Unicode and then into the SQL Server table.
What hoops do I have to jump through?

Thanks!

RobR

Top

RE: Store Japanese characters from FoxPro into SQL Server? by Leemi

Leemi
Wed Aug 04 14:45:41 CDT 2004

Hi Rob:

I have not tested this, but I will give it a shot.

Look at the Strconv() function in VFP to convert the string to Unicode. On
the SQL Server side, I think you need to set the code page of the SQL
Server database to Japanese. However, I could be wrong on this point.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Greetings!

>I have an application that can happily store and retrieve >Japanese
>characters into a stand-alone FoxPro database. Now I need >to write them
>into nvarchar fields in SQL Server tables. SQL Server is >expecting them
in
>Unicode.

>I have an edit box into which I can enter Japanese >characters through an
>input method editor. I haven't been able to figure out >how to massage
those
>characters to get them into Unicode and then into the SQL >Server table.
>What hoops do I have to jump through?

>Thanks!>

Top