sqlconnect

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
    - Negative numbers shown as 'C' type Hi All, I am facing a strange problem! I have two numeric values (captured from text boxes) which I am trying to add and it works fine for positive numbers. When one of them is negative, an error is thrown by foxpro that there is data type mismatch. I had debugged the application and checked the type of both the values. The negative value was shown as 'C' type by the debugger. However, when I tried the following statement, TYPE(txt_box.value) 'N' was returned, but the debugger continued to show the value as 'C' type. The idea was to convert the value to 'N' if it were 'C' type before attempting to add the two values. But, I am not able to do this since TYPE(txt_box.value) returns 'N' though it is considered as 'C'. Anybody knows how to get over this problem? Is it a bug in foxpro 8? Thanks, kd Tag: sqlconnect Tag: 207645
  - 2
    - parse website _cliptext for name, email, web URL, phone, cellphone, street, city, zip I need a routine to parse _cliptext for name, email, web URL, phone, cellphone, street, city, zip, etc. I.E. an Address grabber that will slice and dice _cliptext for replace fieldname in the current record when I rightclick (On Key Label RightMouse Do Parse.prg) Usually, but not always, each of the fields I copy to _cliptext is separated from the next by a carriage return chr(13) Parsing is getting pretty hairy because I'm grabbing more than one field at a time to the clipboard from a VARIETY of websites, each layed out differently. There is no telling whether I will be grabbing a persons name, his email, his cellphone, his home address, his web site. or a combination of 2 or three things. One website will show phone preceeding email and while another will display the same information, with email preceeding the phone number. The next person's information will be missing the phone, but show his address or something like that. Wondering if anyone has some code already written that would help me. Up until now I have stripped out carriage returns along with other funny characters Chr(1... through 31), and done tests on a single line _cliptext looking for clues like "@" (email), "www" (website), "Phone" (phone). Now I'm thinking it is better to leave the carriage returns in, count the lines using memlines(_cliptext) and categorize mline(_cliptext,1) ....2....3, store each line to memory variables m.phone, m.cellphone, m.street, m.email, m.website Any help appreciated. John "J.J." Jackson Tag: sqlconnect Tag: 207627
  - 3
    - Data not updating We have just noticed a problem in one of our programs where data is not updating right. A VB program updates a FoxPro table, and the program in FoxPro does not see the changes. The only way the changes showed were if the VFP program exited and came back in. We then tried it again (with the same problem) and this time did a browse table. In the browse, the update had not happened, but when we clicked on the row the data all of a sudden updated. What possible settings could be missing for this? Why isn't this updating? -- Altman VFP8 SP1 Tag: sqlconnect Tag: 207624
  - 4
    - ReFox XI for VFP9 ReFox XI for VFP9 (and all older versions of FoxPro) just launched new branding level III with compression - 100% safe protection web.telecom.cz/refox/index-en Tag: sqlconnect Tag: 207622
  - 5
    - SQL SELECT DISTINCT Hi, I want to list any duplicate records in my table. How can I do it with a SQL SELECT DISTINCT command? Thanks Derek Tag: sqlconnect Tag: 207582
  - 6
    - does exe file compiled on VFP 7.0 work on win95? ZG9lcyBleGUgZmlsZSBjb21waWxlZCBvbiBWRlAgNy4wIHdvcmsgb24gd2luOTU/IA0KDQpxdWVz dGlvbiAjMjogaSBuZWVkIHRvIHVzZSBjb21tYW5kIGV4ZWNzY3JpcHQoKSwgYnV0IGFzIGkgdW5k ZXJzdGFuZCB2ZnAgNi4wIGhhc24ndCB0aGlzIGZ1bmN0aW9uLiBpcyB0aGVyZSBhbnkgb3RoZXIg ZnVuY3Rpb24gbGlrZSBleGVjc2NyaXB0KCkgaW4gdmZwIDY/DQoNCg0KDQp0aG54DQoNCg== Tag: sqlconnect Tag: 207581
  - 7
    - SQL Server blocking using remote view Hi, I am using remote view to access sql server database, I have a problem that, my 2nd instance of app be blocked. After some investigation, we found that SQL server block one of my instance since it is blocked by another. I am using auto transaction, optimistic table buffering, share connection. I would able to solve it by adding (NOLOCK) in my sql statement. No blocking shown in enterprise manager. But why it cause blocking? Thank you Tag: sqlconnect Tag: 207575
  - 8
    - Hiding tables and class libraries during deployment Hi All, I need to deploy a foxpro application. The tables are foxpro tables and the project also has .vcx files. How to package the tables and the class libraries so that, when the application is deployed, the tables class library files are hidden, even if the customer install visual foxpro developer's kit? Regards, kd Tag: sqlconnect Tag: 207574
  - 9
    - Help in mypro.prg An extensive textbox was programmed in fox2.x and I'm upgrading to vfp9. I get an ERROR row and colum off screen. The program runs fine under vfp but not as an executable. The beginning of the prog.prg is SET READ BORDER ON STORE .T. TO MORE I can't find where the program determines the size of the box. What is MORE??? It doesn't show up in the code reference with a definition. I need lots of help with this. Thanks in advance. Tag: sqlconnect Tag: 207572
  - 10
    - cursoradapter.recordrefresh I wish to get the autoid from sqlsever when inserting a new record. The vfp9 recordrefresh only seems to work if i in addition maintain my own unique id and specify itin the keyfieldlist Am i missing something? thanks Greg Tag: sqlconnect Tag: 207571
  - 11
    - Using SYS(3050) One of our customers has suggested using SYS(3050) to limit the memory use of VFP (they suggest 512Mb) when packing large tables (2Gb). They suggest this is only nessecary on Windows 2003 server standard editon I am reluctant to impliment this for all our customers as i was under the impression that VFP was the best memory manager. Does anybody have any tips regarding this thanks greg Tag: sqlconnect Tag: 207568
  - 12
    - Word AUtomation I have several users running a program where I call an existing Word.doc file using getobject. Only one of them is having a problem with opening up a doc file. I am using the automation as below" *This is what is in the database lastid.lscript2 *C:\samples\fee.doc Selct 0 Use lastid FADR = alltrim(lastid.lscript2) oWORD = GetObject(FADR) WITH oWORD .APPLICATION.WINDOWSTATE = 1 .APPLICATION.VISIBLE = .T. ENDWITH Close Databases The reason why I am using a variable is that I open different word.doc files depending on selection of the user. Is there a better way to open an existing file using the word automation?? Thanks in advance for all the help you all have given me in the past. TonySper Tag: sqlconnect Tag: 207557
  - 13
    - FoxPro 2.5 and VFP 6.0 All, hope I'm in the right newsgroup. Hope I can explain my problem. I have an excel file which I've converted via DataJunction to a foxpro 2.5 table. I'm having trouble with when it comes to reading foreign characters. MEANING: It doesn't read foreign characters! I've got wierd characters on a lot of the foreign records. I think it has to do with the codepage 437 not being able to display the characters correctly. If I open the original excel file, it displays fine. In foxpro 2.5 version it does not. Depending on if I am at home or work version 6.0 may or may not. When I open in 2.5 it opens fine but displays poorly. When I try to read it in with VFP 6.0 it states that the file "is not marked with a codepage". It asks for me to choose a codepage. I've been choosing 437 and 1252 in different tries with varying success. What I need is for the version 2.5 to display them as well as can be done for DOS. Am I on the right track? Right or wrong, could someone offer any insight what might be happening? Regards Dale Jones Tag: sqlconnect Tag: 207552
  - 14
    - set coverage Hi friends does set Coverage to ... command works in runtime ? i just want trace sequence of execution in runtime.. Thanks -- cheers Tag: sqlconnect Tag: 207546
  - 15
    - 2 VFP questions I just created a little VFP executable (.exe) that simply asks the user for a string and does some processing. It returns another string that gets placed in the clipboard, _CLIPTEXT. Question 1: The simple PRG that is part and parcel of the project (the entirety, so far) defines a window and does a GET and READ. That Window's OK, but it's shown in a VFP main screen. Is there a way to dispense with the screen and just have my window show up, the one I defined like this: DEFINE WINDOW browtbl FROM 10,10 TO 23,90 FLOAT ACTIVATE WINDOW browtbl @5,5 say 'Show newsgroups with what in the name?' GET lcstring READ DEACTIVATE WINDOW browtbl Question 2 (probably more difficult): What I'm really after is a way to keyboard this text where the mouse cursor happens to be when I call this. I haven't even attempted this, thinking it can't be done in FoxPro. Instead, I write to _CLIPTEXT. It works, but I lose my former clipboard contents, occasionally a problem. The mechanism I use here is to place my mouse cursor in some zone such as one of the editing regions in a Google Groups search engine screen (it's designed for that, actually). I then call my EXE with a macro utility I use that's called with a keyboard shortcut. My macro utility pops up a "popbox" from which I pick a button-icon representing an action (in this case, my EXE). When my utility disappears (it does automatically) my mouse cursor should be where it was before the utility was called. I'd like to have my EXE actually write into where my mouse was initially rather than my having to paste the clipboard contents? Is that doable? Thanks for ideas!! Tag: sqlconnect Tag: 207545
  - 16
    - sendkeys wont work Hi friends I have a pageframe with 10 tabs on a form. i have a command btn which has hot key (R).I am calling that hotkey programmatically (using sendkeys ) at different places as it is invisible to user. it working beautifully but it wont work if any grid has focus.(BTW the grids r readonly) any ideas on this please Thanks -- cheers Tag: sqlconnect Tag: 207544
  - 17
    - white screen on Exit I upgraded from 2.x to vfp 9 and my application is working perfectly (Thanks to your help) However, when I run the exe and click on Exit from a screen - it flashes white and then closes. How can I eliminate the white screen? Tag: sqlconnect Tag: 207538
  - 18
    - Problem with SQL sub-select and null dates Hi, I am having problems with an SQL select where the sub-select yields a null date value, as the field in the original select does not seem to equate to the null date. I get no records returned. The SQL select statement below works fine when there is a date in the counts_dt field, but does not work when the sub-select yields a null date value. SELECT * FROM COUNTS WHERE counts.counts_dt = (SELECT distinct MAX(isnull(c2.counts_dt,NULL)) FROM counts c2 WHERE c2.property = counts.property AND c2.unit = counts.unit AND c2.cntitem_id = counts.cntitem_id AND c2.cnttype_id = counts.cnttype_id) Any help would be appreciated. Thanks in advance, Pauline Tag: sqlconnect Tag: 207532
  - 19
    - Progress bar One of my applications needs to run quite heavy select statements on large tables, and also quite time-consuming indexing operations. How can I: - Update a progress bar during such a heavy database operation - Give the user an option to cancel an operation after it has started. Any ideas would be highly appreciated. Aaron Tag: sqlconnect Tag: 207525
  - 20
    - Virtual Private Networks and VP6 I've developed an application use VP6. Users are using a VPN with cable and DSL. They say it runs a little slow. The application is loaded on the local machine and it looks to the server across the network for the data. Is there anything I should have done or could have done to make processing the information quicker. Note I developed the application use all free tables. Rusty G Tag: sqlconnect Tag: 207522
  - 21
    - Problem with Menu I am having problem with the menu in my application only in Development environment. When I create EXE file and run then it works without a hitch. I have over 130 menu items that comprise of 8 at the menu bar level and remaining are submenus of these 8 main menu items. The application is a multi-user application and I need to enable/disable menu items depending on each user's access levels. The user access levels are stored in a dbf file. I am achieving this by placing an expression in SKIPFOR field of the mainmenu.mnx file. Here is the relevant code: SKIPFOR field -> ifuseraccess(cUserid,prompt) Function IfUserAccess(cUser,cPrompt) Local nCurarea,lFound if cUser=='SUPERMAN' && For SUPERMAN, all options are enabled. lFound=.t. else nCurarea=select(0) usefile('useraccess') select Useraccess set order to 1 lFound=seek(cUser+cPrompt) select (nCurarea) endif Return lFound The problem is that as long as I populate the SKIPFOR field for about 50 items or so, it works with no problem. As soon as I go upto 60 items or more and run the application, the main menu bar displays fine but when I click on any of the items on the menu bar, it doesn't show the dropdown menu. I have to repeatedly click on a menu item for show its dropdown items. Once the dropdown is displayed for one menu bar item, I can slide left or right to other items and the dropdown menu will show but if I move the mouse away from the menu bar and try to go back again I run into the same problem. It appears to be a speed issue but I am not sure. The compiled EXE file works absolutely fine. I am using VFP 6.0 on a PIII 900 mhz. machine under XP PRO, Enterprise edition. I will appreciate suggestions from the experts here as this problem is really annoying and slowing down my development process. Thanks. Tag: sqlconnect Tag: 207514
  - 22
    - SQL Question How do I read a field that has [ it's name. See custaddr.addr[1] below. Example sql = "SELECT co.[co-num] as conum, custaddr.addr[1] ," sql = sql + "FROM CO INNER JOIN custaddr ON " sql = sql + "co.[cust-num] = custaddr.[cust-num] AND co.[cust-seq] = custaddr.[cust-seq] " sql = sql + "WHERE co.[co-num] = '" + txtOrderNum + "' " Tag: sqlconnect Tag: 207513
  - 23
    - How to make STR(14.2) display 14.2 as string? Hi All, I am sure there is an answer to this that I don't know of! I need to concatenate strings and values and display decimals as strings. For example: ?"Amount Due: $. " + STR(14.2) displays Amount Due: $. 14 Is it possible to diplay the string as Amount Due: $. 14.2 Thanks. Tag: sqlconnect Tag: 207503
  - 24
    - can not update Oracle database with a remote view Hi, we are using remote views to store new records into an Oracle databases and we have a very special case where the tableupdate(.T.,.T.,"tabla") command is rejecting the insertion of records, please note that this trouble arises just in one of the two workstations we are using for the development, and as a fact, both computers are succesfully updating oracle databases on three different Oracle database servers and the trouble happens only on the fourth Oracle server both workstationss are using VFP 6.0 installed from the same CD to eliminate application bugs we have tested direcctly from the command window the following Use "remote view" replace key_fields with 99999 ?tableupdate(.T.,.T.,"remote view") ----> this returns .F. if after this, we execute again the use "remote view" command, we get an error message that says that we can not insert a reciord with null values.. we have confirmed for sure that there are absolutely no restrictions for NULL values in the Oracle database... this is a specific workstation trouble we have verified that we have the same settings for the DSN in the MS Windows ODBC sources we are using the same Oracle8 ODBC driver I would appreciate any suggestion of what to compare between both workstations in order to diagnose and fix this trouble thanks in Advance Oscar Taboada Tag: sqlconnect Tag: 207502
  - 25
    - Problem With Vfp8 Hi 2 all. The vfp8 exe file are not runing when i bulid this project into vfp7 it runs. i copy all vfp8 dll files into project directory.i have winxp install. waiting for good reply -- Qaiser Me Tag: sqlconnect Tag: 207501
- Next
  - 1
    - Distributing Application: Netsetup wouldn't work, Disk144 does I have spent over 6 hours today trying to make my distributed program work using Netsetup in step 3 of the Setup Wizard in VFP 6.0. With the Netsetup, the application installs fine and some options even work. However, I have two databases that are distibuted with the application named wwdata and wwtables. Database wwdata has its dbf files stored in \\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the application tried to open a table in wwtables, I keep getting the message "Error instantiating cursor object. File City not found in \\....\wwtables.dbc" or something like that. I tried numerous times by cleaning up the project and making sure that dbc file is not corrupted or something, but couldn't get rid of the error. Finally, I reluctantly selected the 1.44 MB option (I want to distribute the application on a CD in stead of floppies), and BOOM, it work the first time installation. However, it created six subdirectories DISK1 to DISK6 in the main directory named DISK144. Does anyone know the cause of this behaviour and is there any other way I can create Distribution files under one directory. Thanks in advance for heliping out...... Tag: sqlconnect Tag: 207488
  - 2
    - How do I capture mouse events to a control - MouseHook Hello, VFP 9 WIN2K I need to capture the mouse events for a specific control and when done with the control return the mouse events back to normal. Does anyone know how to do this in VFP Thanks in advance, -CraigB Tag: sqlconnect Tag: 207482
  - 3
    - I am looking for a 3rd Party VFP friendly RTF Reports ocx or dll product Hi All, I have been using Microsoft's richtx32.ocx in conjunction with apiprinter.vcx by Rasmus Moustgaard to view and print rtf documents created in MS-Word. I do not need the end-user to be able to edit the document. I am in the market for a integrated replacement control that will HANDSOMELY print and print preview MS-Word created RTF documents. Also, looking to be able to distribute the control royalty free. Any suggestions would be appreciated. Best Regards, Tom Clark Tag: sqlconnect Tag: 207479
  - 4
    - forrm.autocenter I have encountered an issue with some of my forms. All of my forms are based on a class called cform. Cform has its autocenter set to .t. and this works just fine. I have a few forms that I don't want to autocenter to I changed that forms value to .f.. But, their still autocentering. Its not the foxuser , and ini or some registry setting. I have no code in cform to force it back to .t. And after the form has run a check of that property reveals it to still be .f. Suggestions? Alan Tag: sqlconnect Tag: 207469
  - 5
    - Error opening exe I'm upgrading vfp 2.x to vfp 9. I fixed all compiling errors - and built a new.exe. When I run new.exe I get an the error Window 'command' has not been defined. I can click ignore, the main menu runs but it then claims my files are corrupt (which they are not because I checked them). Tag: sqlconnect Tag: 207465
  - 6
    - Class location I have put the classes in my project into files according to logical grouping. So sales.prg, purchases.prg, stock.prg etc. I am finding it a bit of a pain however trawling through pages of code to get to the bits I want. A colleague of mine who is experienced with C and Delphi says he normally puts each class into a file of it's own. Do you do this? Is it a good idea? -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.accountancy-software.co.uk/pegasus-opera-ii/pegasus-opera-ii.php Tag: sqlconnect Tag: 207455
  - 7
    - Build Project Error When I try to build project, I get this error: Program d:\windowwizard\prgs\winwizprocs.prg has the following errors: Unknown AARRAY - Undefined Form d:\windowwizard\forms\frmcustomerentry.scx has the following errors: Unknown ALEADTYPE - Undefined Here is the source code in the project I am trying to build: Public aLeadtype Dimension aLeadtype[5,2] fillarray(@aLeadtype,"'A','Architect','B','Builder','P','Private Owner','R','Renovator','D','Dealer'") Function Fillarray(aArray, cValues) Local nLen,i,cValtype for i = 1 to alen(aArray) cVal=token(cValues,',',i) do case case type(cVal)='L' aArray[i] = evaluate(cVal) case type(cVal)='C' aArray[i] = strtran(cVal,"'",'') otherwise aArray[i] = val(cVal) endcase next return aArray Any ideas are greatly appreciated. BTW, Token is another function that I wrote and that function works flawlessly and returns expected values. Thanks. Tag: sqlconnect Tag: 207453
  - 8
    - Outlook Mail Automation Hi We have developed a VFP6 app for a customer that sends mail through Outlook. However our customer doesn't want all the recipients to be visible to each other so I thought it would be ideal to use BCC if it is available. I am currently using the following code to handle the mail olMessage = olOutlook.CreateItem(olMailItem) olRecipient = olmessage.Recipients.Add(addresslist) olmessage.send() Could this be modified to send via BCC instead of straight addresses ? Thanks in advance Andy Tag: sqlconnect Tag: 207448
  - 9
    - slow reporting With REPORTBEHAVIOR = 80, a report preview pops up instantly. With REPORTBEHAVIOR = 90, the same preview takes 12 seconds to appear. Is that normal? Tag: sqlconnect Tag: 207435
  - 10
    - Excel error I am getting a strange Excel error in my application. <snip> tmpsheet=getobject('', 'excel.sheet') XLApp=tmpsheet.Application XLApp.Visible=.f. <snip> I am getting an error on the "XLApp=tmpsheet.Application" line. OLE error code 0x80010108: The object invoked has disconnected from its clients Can anyone tell me how to fix this? Thanks, Scott Tag: sqlconnect Tag: 207434
  - 11
    - VFP9 in MSDN? Anyone know which MSDN distribution will include VFP9? I was expecting it in the January shipment, but no dice. Yes, I know it is available for download, but I live out in the boonies and have a snail-like dial-up connection that gives me 26kbps on a good day. :^( -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: sqlconnect Tag: 207426
  - 12
    - VFP 9 Rebate offer This may be old news to some: watch for url wrap [ http://www.microsoft.com/products/info/popup.aspx?view=22&type=rebate&cont ent=7b9bb6aa-f6c0-43b4-b315-6cfd9eb3e39a ] and of course - buy yer VFP Version 9 here: http://www.foxtoolbox.com/ Enjoy ! mondo regards [Bill] -- William Sanders / Electronic Filing Group Remove the DOT BOB to reply via email. Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html Mondo Cool Satellites -> http://www.efgroup.net/sat VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting mySql / VFP / MS-SQL Tag: sqlconnect Tag: 207421
  - 13
    - Transaction problem in VFP9 Dear all, The code beneath generates an error in VFP9. In VFP8 it runs fine. The purpose of the original code is to store data from a view into the database. The sample code doesn't really make sense anymore. We stripped the code down to its bare minimum. It's just a way to show the error. We don't think this code is illegal. So, is there a bug in VFP9? Regards, Roel, Bas and Benno. *=========== BEGIN CODE ============================ CREATE DATABASE database OPEN DATABASE database CREATE TABLE test (FIELD_KEY I, FIELD_DATA I) INSERT INTO TEST (FIELD_KEY, FIELD_DATA) VALUES (0, 0) CREATE SQL VIEW MYVIEW AS SELECT * FROM test USE MYVIEW IN 1 CURSORSETPROP("buffering", 5, 1) CURSORSETPROP("keyfieldlist", "FIELD_KEY", 1) CURSORSETPROP("UpdatableFieldList", "FIELD_KEY, FIELD_DATA", 1) REPLACE FIELD_DATA WITH 1 IN 1 SAVE_VIEW() APPEND BLANK IN 1 REPLACE FIELD_KEY WITH 1 IN 1 SAVE_VIEW() PROCEDURE SAVE_VIEW() LOCAL nRecno nRecno = GETNEXTMODIFIED(0, 1) BEGIN TRANSACTION GOTO (nRecno) IN 1 IF (nRecno > 0) REFRESH(1, 0, 1) CURVAL("FIELD_DATA", 1) ENDIF TABLEUPDATE(0, .F., 1) END TRANSACTION ENDPROC Tag: sqlconnect Tag: 207420
  - 14
    - valid views built in view designer can't be opened by view designer When building remote views, I've noticed that I can build queries with the View Designer on back ends that have non-Fox features, like spaces in the field names. The View Designer works fine, the query works fine. But if I try to reopen the view with the View Designer, I get "syntax error" messages, so if I want to modify the view, I have to do it programmatically. The View Designer in VFP9 is very good, and a big improvement over VFP8's (which was a big improvement over VFP7's). But it really should be able to open views that it itself created, don't you think? Tag: sqlconnect Tag: 207419
  - 15
    - Reset Browse Last to match Browse Preference? Reset Browse Last to match Browse Preference? I have about 6 aliased and related browse windows of the same .dbf that I'm using to manually clean up data. The records are quite long so even with some fields sized smaller than their actual field length in the browse window, I still have to scroll right and left as I go about my cleanup, or expand a field (with my mouse) I have covered up, to check it or enter data. As I skip back and forth and alter the alignment or size of the displayed fields I want my changes to the browse windows to be kept and reflected with a Browse Last, WHICH THEY ARE. That's why I'm using Browse Last (from a On Key Label F8) Anyhow, sometimes things get screwed up and I wish I could revert one or more of the windows back to my more or less starting browse appearance, like with a Browse Preference to sort of reset things and then go back to using a Browse Last. I don't think Browse Preference and Browse Last play well together. They seem to be totally independent. Isn't there a way to get Browse Last to absorb Browse Preference? Is there some other work around i.e. a way to set up a particular look for all the browse windows that will be a sort of reset for Browse Last? -- JJ John "J.J." Jackson Tag: sqlconnect Tag: 207418
  - 16
    - execute pc code from a command button What is the proper procedure that would be used to have a command button do something like: comment - file copy in process y:\ MD test c: CD\temp COPY *.* y:\test comment - file copy complete Dan Tag: sqlconnect Tag: 207417
  - 17
    - Store column positon and width. Hello all, I would like some advice, what is the best way to store grid column positions and width. I thought about using .ini files. Any advice would be appreciated. Regards Richard -- To reply remove 'NoSpam' from email address Tag: sqlconnect Tag: 207408
  - 18
    - blat Can't use Blat if you have Norton Antivirus installed! Scan type: Auto-Protect Scan Event: Threat Found! Threat: Bloodhound.OutEmail File: C:\WINDOWS\system32\blat.exe Location: Quarantine Computer: STEVEFISHER User: steve.fisher Action taken: Quarantine succeeded : Access denied Date found: 10 February 2005 13:43:02 I haven't worked out how to exclude blat from scan. Everything is greyed out on my machine so will have to check the w2003 server and the book. Steve Tag: sqlconnect Tag: 207403
  - 19
    - error "File not open" when building For the past couple of days this error has appeared when I try to build a project in FPW2.6 I click "build", then select "executable" and when I click OK, instead of asking for the output file name it just says "File not open" Why? I've tried CLOSE ALL, CLEAR ALL but the only thing that seems to fix it is quit and restart. -- TIA Andrew Howell Tag: sqlconnect Tag: 207396
  - 20
    - RUN exe and hide the box This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C50F6F.FD914630 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, How do i "RUN ipconfig.exe > ip.txt" by not showing up the disturbing = dos look windows box ? I can't use /N7 because I need to read for the created ip.txt=20 regards Hoe ------=_NextPart_000_000E_01C50F6F.FD914630 Content-Type: text/html; charset="windows-874" 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=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2135" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>How do i "RUN ipconfig.exe > = ip.txt" by not=20 showing up the disturbing dos look windows box ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I can't use /N7 because I need = to read for the=20 created ip.txt </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML> ------=_NextPart_000_000E_01C50F6F.FD914630-- Tag: sqlconnect Tag: 207392
  - 21
    - How to print continuously Hello, I am trying to output my report to a roll of labels on my printer but it skips at the end of each page. How can I make it to print continuously without the page break? Thanks. -- jw Tag: sqlconnect Tag: 207391
  - 22
    - Test dropped-collapsed state of dropdownlist Is there any way to test the state of a dropdownlist to determine if it is currently dropped or collapsed? I'm looking to write a procedure to toggle it, but not knowing its current state makes this a wee bit challenging. Perhaps there is another way, but right now I have tunnel vision and seem to want to do it this way. Jim Tag: sqlconnect Tag: 207385
  - 23
    - Printing Labels from record to record. There has to be a way but I have not stumbled on it yet. I want to print labels between records. Something like label form mylabel record 1 to record 8. Tried all but between does not work, less than greater than don't work. What works. Do not know what I would do without all the help I get on this newsgroup. TonySper Tag: sqlconnect Tag: 207381
  - 24
    - Memo Binary What is the Field type code for Memo binary? i.e. C Character, M Memo. Many thanks Shahriar Tag: sqlconnect Tag: 207355
  - 25
    - Text not showing Upgrade Fox 2.6x to 9.0 A screen contained text on upper portion and controls on lower portion. The screen contols work but the text doesn't appear. In a .prg reads cNotes = ; "^ XXXXX XXXXXXXXXX# XXX: XXXXXXXXX-XXXX " +; "XXXXXXXXX XXXXXXXXXX ^^" +; WRAP("This xxxxxxxx requires multi-level " +; "contractors to place job titles in the xxXXX " +; "where the selection decision is made for " +; "those jobs (Higher Level Plan) rather " +; "than in the XXX where the jobs are " +; "physically located (Lower Level Plan). ",104) +'^^'+; WRAP("These job titles remain in the Workforce " +; "Analysis of the Lower Level Plan but " +; "are excluded from the Utilization Analysis " +; "and Goals and Time Tables of the " +; "Lower Level Plan.",104) +'^^'+; "These xxx xxxxx are included in " +; "BOTH the Workforce Analysis and Utilization " +; "Analysis and Goals ^and Time Tables of the " +; "Higher Level Plan.^^" +; WRAP("The affected job titles are marked with an "+; " * when they appear in both plans. " +; " " +; " ",104) This is info only - how can I get it to show on the screen? Thanks. Tag: sqlconnect Tag: 207351

hi sir.
my problem that when i make sqlconnect(connection name,sql,query name) it
dosen't wait untill the query complete with all data and the procedure go to
the next step in the next line.
is there any way to wait untill complete all sql data in the query and go to
the next line?

Top

Re: sqlconnect by Bernhard

Bernhard
Wed Feb 16 05:18:04 CST 2005

Hi mohamed

> my problem that when i make sqlconnect(connection name,sql,query name) it
> dosen't wait untill the query complete with all data and the procedure go to
> the next step in the next line.
> is there any way to wait untill complete all sql data in the query and go to
> the next line?
I think, your above line should read like this:
SQLEXEC(connection_handle, sql, query_name)
and not
SQLCONNECT(...)

Something switches your sql connection into asynchronous mode.
You can switch back by:
SQLSETPROP(nStatementHandle, "Asynchronous", .F.)

Another way could be:
lnResult = SQLEXEC(connection_handle, sql, query_name)
DO WHILE lnResult = 0
lnResult = SQLEXEC(connection_handle)
ENDDO

Regards
Bernhard Sander

Top