how to create a string of values that can be used to insert in 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
    - top level form menu I have a menu on a top level form. When I select the menu pads with the mouse all works as expected. However, I'm having difficulty getting that top level form menu to activate on an ALT+ key sequence. Example: The \<File menu pad appears normally and appears that an ALT+F would activate it, but it does not. The menu is being called from the INIT() of the form as: SET SYSMENU OFF DO mymenu.mpr WITH this, 'mymenu' Are there any special considerations with top level form menus to get them to trigger when an ALT+ key sequences are typed? -- Alec Gagne Crimestar Corporation www.crimestar.com Tag: how to create a string of values that can be used to insert in SQL server Tag: 227367
  - 2
    - skype Hello and thanks in advance for the help. Has anyone developed apps using Skype? Do you have any sample code you'd be willing to share? I can't quite figure out what Skype wants me to do to use their control. Thanks for the help. Jeff Tag: how to create a string of values that can be used to insert in SQL server Tag: 227362
  - 3
    - VFP: Remembering maximized window position Hello, If I close a maximized form, I want the position maximized the next time the form is run. I suppose this is INI issue, but not sure how to implement. Please help. RS Tag: how to create a string of values that can be used to insert in SQL server Tag: 227354
  - 4
    - Editbox lost focus issue I can't reproduce the following 100% of the time, but it seems to me that if I exit an editbox in one of my forms by clicking on a listbox (and/or perhaps elsewhere) on the same form, the underlying tables are not always updated properly. The update is accomplished via sql statements in the lostfocus() event of the control. There is no controlsource and the fields in question are character memo fields. The lb does drive the table that stores the data, but I can verify that this is not a case of the data being written to the wrong record. One obvious question is: Is there any way to exit an eb control that won't fire the lostfocus() event? TIA. -Lew Tag: how to create a string of values that can be used to insert in SQL server Tag: 227351
  - 5
    - Monitor Network Activity Does anyone know of a way to monitor network activity to a specific IP Address programmatically? Hereâ??s the situation. We have an IP Phone system in the office (Itâ??s a Mitel system if that makes any difference). Our computers are all connected to our phone via network cables, which is then connected to our network. Each phone has its own IP (i.e. 10.10.2.x) Basically, Iâ??m looking for a simple way to check to see if someone is on their phone. We could become certified with Mitel to develop software for our phone system, but that requires training, time, money, etc... and it is probably overkill for what we currently need. So I figured if we could just pole the network activity to the phone, that would probably indicate to us that the phone is in use. Any ideas on how this can be accomplished? Is there any APIâ??s or something else that would work? Thanks in advance, Jerry Tag: how to create a string of values that can be used to insert in SQL server Tag: 227349
  - 6
    - Time limited demonstration program Where can I find instructions on the best way to create a time limited demonstration program? I'd like to create one of those that dies after so many days and they have to enter a registration code to get it going. Thank you Tag: how to create a string of values that can be used to insert in SQL server Tag: 227347
  - 7
    - converting from vb Hi there, need some help here. I'm developing a program to extract data from a smartcard. The sample program from the development kit that come with the smartcard reader was develop using VB. I'm having problem in getting the picture from the smartcard into my vfp form. In VB, the code is : Set Image1.Picture = MyKad1.Photo In my vfp form, I put Thisform.Image1.Picture=MyKad1.Photo but when the code is run, got error message, invalid data. Anyone knows how to do it in vfp. Mykad1 is actually an ocx for the smartcard reader. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227340
  - 8
    - VFP 9 SP 2: How is It Running? I installed VFP 9 SP 2 not too long ago. Since then, I have observed a number of crashes. SP1 was stable. I write this as I just had to delete foxuser.* AGAIN. This time, it was because I could not modify a table that I needed to change for debugging. I would simply start VFP, do my normal setups, open the table, locate the row, browse, change the value in question, save, and BAM! C0000005 everytime! Deleting foxuser.* got rid of the problem. Rebooting did not. And how have your VFP 9 SP 2 experiences been? Is anyone using it? (Is it really my turn to be bleeding edge, or is everyone else doing fine with it?) Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227334
  - 9
    - Street Type Validation Anyone have a street type validation process? I need something that when given a string will return true if the string is a valid street type (including abbreviations). For example, if given "Avenue" or "AVE", it will return .T., but if given "Fred", it will return .F. I'm writing an address parser and need to be able to identify street types. Thanks! Charlie Parker Tag: how to create a string of values that can be used to insert in SQL server Tag: 227329
  - 10
    - VFP 9 SP2: Command Window ?Bug Twice now, my command window has become messed up. Normally, there is space between the leftmost character in each line and the left frame of the window. This has disappeared. Commands still work fine, but the cursor is no longer visible when it is at the beginning of the line. Since I frequently repeat previous commands, this is bothersome. Deleting foxuser.* does get rid of the problem. It also gets rid of my useful settings. At least I have not had to lose a bunch of debugger settings. This has happened only since switching to VFP 9 SP 2. I have not changed the general way that I use VFP since switching to 9. Am I missing a setting? Is there a workaround? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227324
  - 11
    - VFP 9: Maximum String Length According to the VFP 9 docs under "Visual FoxPro System Capacities", the maximum string length is 16777184. What is the true maximum, and where is it documented? Adding characters ten at a time, I created a string of 40 million characters. If I start with one character and double, I get an error 1903 (String is too long to fit.) after 16777216 (2^24). (This is odd since twice that is less than 40 million.) If I start with one character and double up to 16777216, then add 1 MB at a time, I get an error 43 (There is not enough memory to complete this operation.) after 383778816 (over 1/3 GB). Since it is possible to create some very long strings and yet get errors on shorter strings, what are the rules for l-o--n---g strings? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227323
  - 12
    - Illegal regursion in triggers I know there's a way to do this, but I just don't remember. I have a table with a timestamp field which contains the datetime() of the last update and I want it to be updated whenever any change is made to a record and regardless of any table buffering. I'd like to use the update trigger but, of course, updating the timestamp in the trigger just creates the illegal recursion error (as it should). Suggestions? -Lew Tag: how to create a string of values that can be used to insert in SQL server Tag: 227310
  - 13
    - SuperClass Utility for VFP 5 The one I found needs VFP 6 or above. Anyone got a version for 5? Please kindly attach here... -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: how to create a string of values that can be used to insert in SQL server Tag: 227300
  - 14
    - Where are the codings? Hi everyone, I've downloaded a class (.vcx). This vcx is based on a custom class. When I open up the vcx file, there is no coding in the methods but it is working when the method was called. How can this possible? Where are the codes? By the way, I'm new to vfp. Hope someone can explain this to me. Thank you. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227294
  - 15
    - vfp 9 app running in Vista Hi, Our application when running under Vista RC2 has some issues with displaying the forms. Some vfp forms show up fine, but a lot show the form but no title bar or form border, just the grey form area is showing. Is this a known problem, any fixes? Thanks Tristan Tag: how to create a string of values that can be used to insert in SQL server Tag: 227290
  - 16
    - VFP9: Keypress via command button? Hello, This stupid question has got me stumped! How do I press F2 key within command button? Way back when I thought INKEY() was the answer, but.... Thanks for the help. RS Tag: how to create a string of values that can be used to insert in SQL server Tag: 227280
  - 17
    - Update SQL problem I'm having some troubles with an update statement, using VFP 9, and it's driving me buggy, might someone see what I've incorrectly done? I have two tables: Master - has dozens of fields, approximately 10000 records Corrections - Has five fields (item, serial, firstrent, origcost, acquired), 500 or so records The last three fields in the Corrections table need to be changed in Master, based on the combination item+serial matching in Master, so I know there are about 500 records that will be updated. When I use the code below, I get 0 records updating. I suspect it has to do with my Where clause, and have tried many different derivations. Can someone help? UPDATE Master; SET acquired = b.acquired, firstrent = b.firstrent, origcost= b.origcost; from Corrections b; where b.item+b.serial = Master.item+Master.serial Thanks- Brian Tag: how to create a string of values that can be used to insert in SQL server Tag: 227274
  - 18
    - Writing to/Reading From USB Device Directly I have a device on a usb port which I can successfully write directly to. However, I am experiencing difficulties reading directly from the port. Everything below works (the commands go to the device) until it gets to the readfile portion. The device is sending data back but the readfile() is not capturing it. Any ideas? *--lc_DeviceName is returned from SetupDiGetDeviceInterfaceDetail lh_Device = CreateFile(lc_DeviceName, ; GENERIC_READ + GENERIC_WRITE ,; FILE_SHARE_READ + FILE_SHARE_WRITE, 0, OPEN_ALWAYS,; FILE_ATTRIBUTE_NORMAL + FILE_FLAG_SEQUENTIAL_SCAN, 0) IF (lh_Device != INVALID_HANDLE_VALUE) && Later test using DeviceIoControl From Lh_Device also lw_Buffer = SPACE( MAX_PATH ) lcSendValue = [! U1 MCR 80 T1 T2] + CHR(10) + CHR(13) && a command the USB device recognizes lnWritten = 0 IF WriteFile(lh_Device, lcSendValue, LEN(lcSendValue),@lnWritten,0) <> 0 && 0 is failure *!!!! Success - the device responds to the command sent *!!!! Now capture the data returning from the device (the response) lcReadBuffer = REPLICATE(" ",MAX_PATH) lnBytesReturned = 0 lnCounter2 = 0 *--Latest attempt is to loop through a read for awhile DO WHILE lnBytesReturned == 0 lncounter2 = lncounter2 + 1 IF ReadFile(lh_Device, @lcReadBuffer, LEN(lcReadBuffer), @lnBytesReturned, 0) <> 0 lncounter = 0 DO WHILE lncounter < 50 lncounter = lncounter + 1 DOEVENTS IF !EMPTY(MakeANSI(lcReadBuffer)) ? lcReadBuffer ? MakeANSI(lcReadBuffer) ENDIF ENDDO * ADD GetQueuedCompletionStatus() ENDIF IF lncounter2 = 100 EXIT ENDIF ENDDO ENDIF CloseHandle( lh_Device ) ENDIF Tag: how to create a string of values that can be used to insert in SQL server Tag: 227273
  - 19
    - Trimming combobox length display I have a an array populated from a table [tablename(cid c(8), cdesc(100))] and bind it into a combobox as the rowsource. The problem that I have is the length of the display when using the combo box is showing the whole 100 characters even I only have a maximum 30 characters from my table. Is there anyway i can trim the display using the method above? Thanks. apa Tag: how to create a string of values that can be used to insert in SQL server Tag: 227268
  - 20
    - ToolTipText How does it work? I set textbox.tooltiptext="xxxxx", but when I mouseover the textbox, there was no tooltip! -- .~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org / v \ Simplicity is Beauty! May the Force and Farce be with you! /( _ )\ (Ubuntu 6.06) Linux 2.6.18 ^ ^ 19:42:01 up 26 days 22:07 0 users load average: 1.00 1.00 1.00 news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk Tag: how to create a string of values that can be used to insert in SQL server Tag: 227265
  - 21
    - VFP 5: view parent code I couldn't find the button to view parent codes. Where is it? -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: how to create a string of values that can be used to insert in SQL server Tag: 227256
  - 22
    - Installing VFP6 on Win2K3 Hey All, I'm trying to install VFP6 on our new development "server" (my new workstation...) and I'm stuck at the point where it wants to install the Microsoft JVM. Since that's no longer supported and I'm running Win2K3 64 Bit I'm a little leery... Any words of wisdom? Thanks! Matt P.S. I do have the latest JDK and JRE from Sun installed if that matters. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227240
  - 23
    - VFP 9 Display/Screen Big Problems Hi! All of a sudden, I can't see VFP 9 screen anymore. I deleted the foxuser files and I got a command window floating on my desktop. When I issue a command (like DIR), I can't see the output but it pauses for me to press a key. If anyone has any clue, please help!! Thanks -- Monique. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227237
  - 24
    - Assigning colors to grid cells I wish to display a series of change records in a grid on a form. They are ordered by change date, so that the newest record is on top. I wish to change the color of any cell who's value is different than the cell below it, but am not able to make the grid work this way. I have played with the Dynamic* properties of the columns but this does not really work: On the initial load it seems to work by calling an EXECSCRIPT() which does skip 1 m.Val = table.val skip -1 if table.val = m.val return m.nHIGHLIGHT else return m.nNORMAL ENDIF However, as soon as you start moving through the grid, the colors are assigned strangely. Is there any way to do this using the Grid control, or do I need to build my own control from scratch? Tag: how to create a string of values that can be used to insert in SQL server Tag: 227230
  - 25
    - Class & Project menu popups... How can I get the pad & popup names for the pad/popups that are dedicated to active vfp desktop items? Eg I'm interested in adding stuff to the Class and Project popups. TIA -Lew Tag: how to create a string of values that can be used to insert in SQL server Tag: 227228
- Next
  - 1
    - buy fpd2.6 Hi I want to buy a legal version of FPD 2.6 for personal use. Where can I get it and how do I buy it? Thanx Charu -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/foxpro-general/200610/1 Tag: how to create a string of values that can be used to insert in SQL server Tag: 227221
  - 2
    - RS232 port Dear All, I have a digital scale connected to my PC through RS232 port. I would like to write a program - in VFP9 - what can read the scale's weight. Could anyone help me how can I start programming? Thank you in advance. -- Sandor Tag: how to create a string of values that can be used to insert in SQL server Tag: 227220
  - 3
    - VFP 9: window name What's the name of the window after the command window docked with the property window? I can't close them individually using their own names after they became one. -- iTech Consulting Co., Ltd. Website: http://www.itech.com.hk (IE only) Tel: (852) 2325 3883 Fax: (852)2325 8288 Tag: how to create a string of values that can be used to insert in SQL server Tag: 227215
  - 4
    - VFP 9: Command Window Display I have run into an bothersome difference in VFP 9. I am debugging an program and have a browse in the middle to look at a generated cursor. The command window now displays over the browse. This knocks out using a full-screen browse which I occasionally need. If I click on the command window to move it, I can, but at the cost of the browse disappearing. Is there a setting that I am missing? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227213
  - 5
    - Printing All, I am trying to get FP 9 to print using a print preview component that consists of an ocx wrapper for a dll. The dll will not register as an activex in FP, even though it is registerable with regsvr32. I can get all the way through defining the page layout, and send copy to the printer. At that point nothing appears to happen. No job in the printer object in the control panel, no print preview. I see this in "What's New if FP 8" (haven't got around to 9 yet): "You still can't print reports from within a dll-based vfp com object." So, I'm wondering, does this apply to what I am trying to do as well? Is this still unchanged in 9? Gleason Tag: how to create a string of values that can be used to insert in SQL server Tag: 227210
  - 6
    - FPW 2.6 + Windows 2003 Server + DHCP problems I think we've solved it, but looking for input from others that may have experienced this problem. We have 12 XP Pro clients running our FPW 2.6 application. We recently decommissioned the trusty old Netware 3.11 server and put the DBFs on a Windows 2003 Enterprise server shared folder. Each client has a mapped network drive to the shared folder. We were experiencing problems with the application getting sporadic "File read errors". We found http://support.microsoft.com/kb/297684 and ran "net config server /autodisconnect:-1" on the server. The file read errors continued. We finally traced the disconnects to the time of client DHCP lease renewal. Since we set all the stations to static IP addresses the problem seems to have disappeared. -- Paul Tag: how to create a string of values that can be used to insert in SQL server Tag: 227206
  - 7
    - Getting Started I want to develop a system using client/server using Visual Foxpro... 1. The Microsoft SQL Server, what version should I need if my OS is Windows 2000 Standard Edition? 2. If my OS is Windows 2000, what version of SQL should I need? I need your opinio please...Help me? Tag: how to create a string of values that can be used to insert in SQL server Tag: 227172
  - 8
    - VFP GRID PROBLEM hi all, i am working on client/server application, front hand VFP and backened SQL Server. I am facing the problem in grid. It acts very weird. If the record source of the Grid is SQL Table, sometimes it shows only one record and sometimes blank. In some places, just calling the child form and close it instantly, grid of parent form shows the records properly. It seems to like some refreshing problem. I already breakhead on this thing for long time but i cant get any solution. If any one knows about this problem, please let me know.. Thanks Regards Tassadique Humayun Tag: how to create a string of values that can be used to insert in SQL server Tag: 227169
  - 9
    - Report hangs in FPW 2.6 I am still using FPW2.6 for an application on a Windows2003 Server, with workstations that run Win2000 or XP. Until last week, every report printed fine, but now there is a report that always hangs (hangs both on preview and on printer). The report preview window opens up, but it remains blank for ever, until I kill the ntvdm.exe in the Task Manager. The config.fpw file contains MEMLIMIT=80,16384,32768 since ever. I get the same error on different workstations. I have tried with other MEMLIMIT configurations, but every time it still hangs. Any further suggestions? Tag: how to create a string of values that can be used to insert in SQL server Tag: 227158
  - 10
    - SYS(1104) returns a string value. As per Fox documentation, Sys(1104) should return numeric (0 if successful) data type. I am consistently getting a string value of '956' from within my application. I am using VFP8. Making this call in FoxPro, without starting my application, correctly returns 0. Anyone seen this before? Is this a bug? Thanks Sati Tag: how to create a string of values that can be used to insert in SQL server Tag: 227156
  - 11
    - case statement in remote view? Hi, I would like to create a remote view that includes a field that is populated based on a range of another field in VFP 9. For example, I have a view that returns contact last name, first name. For example: CREATE VIEW contacts CONNECTION contactdb SHARE AS ; SELECT RTRIM(contact.last_name) + ', ' + ISNULL(RTRIM(contact.first_name), ' ') as contact_name ; FROM contact ; ORDER BY contact.last_name I would now like to add another field, an integer, the value of which is determind by the first letter of the last name. The CASE statement appears to be the best choice to me but I'm not sure how to implement it in a view like this. I'm thinking last names starting with A - E = 1, F - J = 2, K - O = 3 and so on. DO CASE CASE BETWEEN(LEFT(contact.last_name, 1) , 'A', 'E') contact.sort = 1 . . . ENDCASE Of course adding the column sort as an integer. Any suggestions? Thanks in advance, Linn Tag: how to create a string of values that can be used to insert in SQL server Tag: 227155
  - 12
    - Data Type Mismatch??? Hi everyone. Can someone please take a look at this code? It's very simple. What I am trying to do here is insert a default date of "12/31/xx" into all inv_date column fields, xx representing the last two digits of the year that the user previously entered. I need to do this so that the original application still accepts the proper date format mm/dd/yy. Here is my code: y = Substr(Transform(lcinput),3,2) replace ALL inv_date WITH ("12/31" + (y)) If I type this code into the Command Window and type ?"12/31/" + y, I get the 12/31/02, if the user entered 2002. However, if I run this in my program, I get and error that states "Data type mismatch". Can anyone help me out with any ideas? Thanks. Arvin Tag: how to create a string of values that can be used to insert in SQL server Tag: 227149
  - 13
    - Microsoft Visual FoxPro Sedna - Community Technology Preview (CTP) October 2006 From http://www.microsoft.com/downloads/details.aspx?FamilyId=808E96E1-3D87-421F-9BA5-4AAFE70C7B21&displaylang=en This download contains latest binaries that are part of Microsoft Visual FoxPro Sedna and the Visual FoxPro 9.0 SP2. This CTP contains two downloads: The Sedna CTP download contains four components: Upsizing Wizard, Data Explorer, NET4COM and MY library for VFP. The VFP 9.0 SP2 CTP download contains a patch that can be applied to VFP 9.0 or VFP 9.0 SP1. This patch includes fixes to the core product and enhancements to the Reporting features. -- Cindy Winegarden MCSD, Microsoft Most Valuable Professional cindy@cindywinegarden.com Tag: how to create a string of values that can be used to insert in SQL server Tag: 227143
  - 14
    - Combobox Displaying Value VFP7 XPSP2 I have a combobox by builder to display 4 fields. when i click on the combo the 4 field are displayed near each and after selecting an item from the combobox, only one field is displayed. My question: i want when i select an item from the combo, the display value to be the 4 fields.as it is displayed when click on the combo before choosing an item. ths in advance Samir Ibrahim Tag: how to create a string of values that can be used to insert in SQL server Tag: 227136
  - 15
    - method parameter I am trying to use an activex method that takes a parameter described as (text as string @) . I know that an @ in front of a parameter makes a variable passed by reference to a function. The compiler gives the same error with the @ in front or without. Placing the @ after the variable name doesn't work either. What is the above syntax telling me? Gleason Tag: how to create a string of values that can be used to insert in SQL server Tag: 227126
  - 16
    - VFP Runtimes Hi, If I have PCs with locally installed runtimes and also the runtimes in the network application directory, do you know which ones it will use? Just thinking of some machines with VFP9 rt installed locally, and want them to ignore those and pick up VFP9 SP1 rt copied to the app directory. Will this work - can I be lazy? Thanks, Neil Tag: how to create a string of values that can be used to insert in SQL server Tag: 227119
  - 17
    - reportlistener orientation problem i can chain two reports together using the report listener just fine, but... report 1 in in portrait report 2 is in lanscape the second report previews only showing half the report. how do i get it to handle this corectly? Tag: how to create a string of values that can be used to insert in SQL server Tag: 227107
  - 18
    - How to reference control within a column Dear Programmers, If you want to set the property in/on a control within a column within a grid if it is a textbox, how do you refer to that. Here is some code within the INIT of the Grid, every thing works great except where noted. DoDefault() *** If the grid does not scroll horizontally, make sure the columns are sized *** properly so the grid doesn't scroll when you tab off the last column Local lnTotColWidth, lnCnt With This .lgridoverridecaption = .t. .AllowHeaderSizing = .f. .AllowRowSizing = .f. .HighlightRow = .f. .Highlight = .t. * set resizable properties For lnCnt = 1 TO .ColumnCount .Columns[ lnCnt ].Resizable = .f. .Columns[ lnCnt ].Movable = .f. .Columns[ lnCnt ].Readonly = .t. The following code generates an error **************** If alltrim(upper(.Columns[ lnCnt ].CurrentControl.class)) = "TEXTBOX_" .Columns[ lnCnt ].loverridewidth = .t. .Columns[ lnCnt ].lgridoverridecaption = .t. Endif ***************** Endfor If INLIST( .ScrollBars, 0, 2 ) *** Calculate the total width of all columns lnTotColWidth = 0 For lnCnt = 1 TO .ColumnCount *** Add-on the width of this column lnTotColWidth = lnTotColWidth + .Columns[ lnCnt ].Width + 1 *** work out if this is the last column If .Columns[ lnCnt ].ColumnOrder = .ColumnCount lnLastColumn = lnCnt Endif Endfor *** Add-on the width of the scroll bar (if required) lnTotColWidth = lnTotColWidth + ; IIF( .ScrollBars = 2, SYSMETRIC( 5 ), 0 ) + 2 *** Add-on the delete mark (if required) lnTotColWidth = lnTotColWidth + IIF( .DeleteMark, 8, 0 ) *** Add-on the record mark (if required) lnTotColWidth = lnTotColWidth + IIF( .RecordMark, 10, 0 ) *** Resize last column to ensure grid is completely filled .Columns[ lnLastColumn ].Width = .Columns[ lnLastColumn ].Width + ; ( .Width - lnTotColWidth ) -1 Endif Endwith Any suggestions ? Regards Craig C. Hudson Sr. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227104
  - 19
    - VFP 9: Alternative to sys(1037) I have been using a keyboard-sys(1037) sequence to change printer orientation. This is a kludge, of course, and occasionally, when I was using the app, it would hang up wait on the printer form. (I never did identify exactly when, but it was when I had switched focus to another program, and only occasionally.) Surely, there must be a better way, one that does not count on the operator being "friendly". I have looked for code to do this. I found two on Universal Thread, but the documentation is rather sparse. Except for my recent excursion into the kernel API, I have not used external routines before in VFP. Is there a good writeup somewhere, something with examples so I can be sure I have it right? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227103
  - 20
    - Report printer driver error with new listener / preview I have just tried creating my first VFP report listener. All I want to do with it is be able to detect whether a user printed from a preview. I subclassed the ReportListener class, but the only change I made to it was to capture lPrint in OnPreviewClose and save it to a property so I could look at it later. I am using the default Preview Container that ships with VFP, with no changes except cosmetic ones (caption, height, etc). This works correctly in that it does allow me to detect whether the print button was hit in the preview. However, I'm having two problems. The first one is that the preview takes quite a long time to load, probably twice as long as if I have SET REPORTBEHAVIOR 80 and scrap the listener. The second problem is that when the user presses the print button, they get an error - 1958 Error loading printer driver. I don't specify print drivers in my reports, they generally just go to the user's default printer. Do I have to set a printer driver somewhere for the listener to work correctly? And has anyone experienced a speed problem using the custom preview? TIA, Jen Tag: how to create a string of values that can be used to insert in SQL server Tag: 227099
  - 21
    - Alias not found error Hi, I have the following code which occasionally errors out on the last line with Alias 'INSTSTOCK' is not found. It's part of a much bigger app. The This.msource property contains pathing information. Can anyone think of any circumstances why this error would happen, because I'm out of ideas. Thanks, Neil ** start code ** if not used("inststock") select 0 use (This.msource + "lb_stock") order lb_stock again alias inststock shared noupdate endif if not used("instcmpnt") select 0 use (This.msource + "lb_cmpnt") order lb_cmpn2 again alias instcmpnt shared noupdate endif if not used("instsalit") select 0 use (This.msource + "lb_salit") order lb_sali8 again alias instsalit shared noupdate endif lnThisavail = 0 select inststock ** end code ** Tag: how to create a string of values that can be used to insert in SQL server Tag: 227097
  - 22
    - Generate a "green application" from VPF Is a possible for VPF to generate a "green application" ? ( It means no need to install the program, just double click the exe file to run the application ) Does any one know it ? Derek Tag: how to create a string of values that can be used to insert in SQL server Tag: 227081
  - 23
    - Aggregate function Count I was wondering if someone can help with a specific select statement. This is the following data: Depodate Casenumber Deponent 10/10/06 06CV112 John Smith 10/10/06 06CV112 Mary Smith 10/10/06 05CV555 John Doe I want to get a table that has the following: DepoDate Casenumber depCnt 10/10/06 06CV112 2 10/10/06 05CV555 1 What I need is, For each case number a total deponent count. So I am trying to use the aggregate function Count. I just can't seem to use it properly. Tag: how to create a string of values that can be used to insert in SQL server Tag: 227074
  - 24
    - View Tree Control ! Hi, Can someone recomend a View Tree Control to implement like a menu with graphics in the options icons and be able to create folders , could be active X control o something easy to implement. Thanks Bye Oscar from Miramar/FL Tag: how to create a string of values that can be used to insert in SQL server Tag: 227071
  - 25
    - blink taskbar Hi, How can I blink my form "reference" in the taskbar. I think that this feature started since XP. Some want to shut it off ... ;-) I want it to act like that with certain "as top level"-forms. thanks in advance regards christophe Tag: how to create a string of values that can be used to insert in SQL server Tag: 227062

I am trying to create a string depending on the cursor fields & its
type to be used to pass it to insert command for SQL server.
I am having 2 problems
1> How to include character fields with quotes, square brackets & other
special characters.
2> How to send date fields.

Rajesh

Top

Re: how to create a string of values that can be used to insert in SQL server by AA

AA
Fri Oct 20 04:00:33 CDT 2006

SELECT sourcecursor
SCAN
TEXT TO lcSQL TEXTMERGE NOSHOW
INSERT INTO SQLServerTable VALUES ('<<TRIM(sourcecursor.field1)>>',
[<<sourcecursor.field2>>],
<<DTOC(sourcecursor.datefield)>>,
<<sourcecursor.field4>>)
ENDTEXT
DEBUGOUT M.lcSQL
n=SQLEXEC(M.connhandle, M.lcSQL)
IF M.n<0
* error handling
ENDSCAN

You can also send variables or cursor fieldnames
SCAN
SQLEXEC(connhandle, [INSERT INTO Target VALUES
(?sourcecursor.field1,?sourcecursor.field2,?sourcecursor.datefield)] )
ENDSCAN
or replace the direct references with variables.
TEXT - ENDTEXT is a convenient way to build lengthy and complex commands
strings into a variable.

-Anders

"Rajesh" <rajeshhalyal@gmail.com> skrev i meddelandet
news:1161314969.786658.105460@i42g2000cwa.googlegroups.com...
>I am trying to create a string depending on the cursor fields & its
> type to be used to pass it to insert command for SQL server.
> I am having 2 problems
> 1> How to include character fields with quotes, square brackets & other
> special characters.
> 2> How to send date fields.
>
> Rajesh
>

Top