DBC Connection to SQL data??

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
    - Creating web-based apps with VFP8 vs Starting with .NET solution Hi all, I talked to a prospect yesterday. He has a plastic bag manufacturer and he wanted to create apps to maintain the data in his manufacturing company. He said that there were already three software companies that gave a proposal to him. I will be the forth. All three companies are offering a web-based applications, thus he insist that mine should be web-based also. Problem is, although I've been using VFP for almost four years by now, I have never touched a web-based application. For more information: two companies (out of three) offered a Linux based solution (I think they'll use php), and the other offered a .net based solution (vb.net for sure!). Question: 1. Anybody got any idea what my selling point should be when I meet him on next the Tuesday? 2. How steep is the learning curve to create a web-based applications with VFP? I'm willing to invest in 3rd party product like WWC if I have to. Any other alternatives? 3. I was planning to buy VS.NET --- not in a near future actually, but if I can get this project, I might decide to buy it sooner. Will it do any help if I develop the apps with VFP ( I have VFP8 )? 4. Considering that I am used to code in VFP, I assumed that it would be much easier for me to create the apps in VFP rather than starting from scratch with VS.NET. What makes me doubt is I read several pages of VB.NET book in our local bookstore this afternoon, and it looks like that VB.NET is designed to create a web-based application from the beginning. The book started with creating a hello world web-based apps. Anybody here ever learn VB.NET with VFP background? Do you have any suggestion? TIA, Willianto Tag: DBC Connection to SQL data?? Tag: 178390
  - 2
    - New msdn.microsoft.com/vfoxpro website layout Surf on over to http://msdn.microsoft.com/vfoxpro/ and have a look at the new Visual FoxPro website. -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy.winegarden@mvps.org, www.cindywinegarden.com Tag: DBC Connection to SQL data?? Tag: 178387
  - 3
    - Mixed colors in grid Hi! I have a grid with 24 columns. The value in each column can be ether -1, 0 or a number greater then 0. In any given row I want the background color to be white for -1, green for 0 and red for the everthing greater than 0. Everthing I've tried so far will ether make the entire row or the entire column one of the colors depending on which row I'm in. I need to have mixed colors in the same row and they need to be retained in that row when I go to the next row. Can anyone help me with this? Thanks Terry Tag: DBC Connection to SQL data?? Tag: 178382
  - 4
    - Refreshing tables in the DE vfp 6.0 Form with private data session and tables in the DE Hello After user click save button the files are updated and fields in window are cleared. How do I refresh the tables in the data environment so that they are up to date? The only way I can think of ensuring the tables are current is by closing the form and opening it again. How do I refresh all the tables in the data environment of a form with the current disk values? Do I have close and reload all the tables? I hope not. Thanks for your advice Al Tag: DBC Connection to SQL data?? Tag: 178380
  - 5
    - Old menus I think I've just discovered that VFP 8 has real trouble when dealing with "old" menus, to the point of C0000005'ing. After I went through and opened all the old menus, allowing VFP to "Convert to new menu format," things were ok. Likely a causal relationship. Anybody else notice this? Eric Tag: DBC Connection to SQL data?? Tag: 178375
  - 6
    - Grid columns I have a grid with 8 columns created in the Visual Class Designer. I'm reassigning the ColumnOrder and nothing is happening. I put a message in the 'Init' of the grid to make sure that I'm editing the correct item in the class. The message came up but the column order stayed the same. What am I missing as the possible problem? Thanks, Chip Tag: DBC Connection to SQL data?? Tag: 178369
  - 7
    - Report remembers printer I developed an application with reports. The problem is, that some of the reports come out of the printer (network printer)I used at development time. It should be printed by the Standard printer of the User. Other reports of the application work as expected. What did I wrong. TIA Michal Tag: DBC Connection to SQL data?? Tag: 178365
  - 8
    - Define Object This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C356F7.16ACF390 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable * While we patiently wait for VFP9, here is an interesting piece of code * DefineObject.prg * VFP8 ONLY ! * TODO: nested objects TEXT TO objectText NOSHOW=20 DEFINE OBJECT Employee AS Name =3D "George" Phone =3D "555-1234" Hired =3D {^1920/01/01} Salary =3D $999.95 Age =3D 93 Weight =3D 184.25 Inactive =3D .F. Pets[5] =3D .NULL. ENDDEFINE ENDTEXT ? objectText oEmployee =3D DefineObject(objectText) SET STEP ON && check oEmployee RETURN *------------------------------------ FUNCTION DefineObject LPARAMETERS objectText IF GETWORDNUM(objectText,1) <> "DEFINE" THEN RETURN .NULL. ENDIF anyObject =3D CREATEOBJECT("EMPTY") linesCount =3D ALINES(objectLines,objectText) FOR counter =3D 2 TO linesCount-1 equalSign =3D AT("=3D",objectLines[counter]) propertyName =3D ALLTRIM(LEFT(objectLines[counter],equalSign-1)) propertyValue =3D ALLTRIM(SUBSTR(objectLines[counter],equalSign+1)) IF INLIST(LEFT(propertyValue,1),CHR(34),CHR(39),CHR(91)) THEN && = String propertyValue =3D SUBSTR(propertyValue,2,LEN(propertyValue)-2) ADDPROPERTY(anyObject,propertyName,propertyValue) ELSE ADDPROPERTY(anyObject,propertyName,EVALUATE(propertyValue)) ENDIF ENDFOR RETURN anyObject ENDFUNC *------------------------------------ I love you fox ;-) ------=_NextPart_000_0008_01C356F7.16ACF390 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Courier New" size=3D2>* While we patiently wait for = VFP9, here is=20 an interesting piece of code</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>* DefineObject.prg<BR>* VFP8 = ONLY=20 !</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2>* TODO: nested = objects</FONT></DIV> <DIV><FONT face=3D"Courier New" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>TEXT TO objectText=20 NOSHOW <BR>  DEFINE OBJECT Employee AS<BR>  =20  Name     =3D "George"<BR> =20   Phone    =3D "555-1234"<BR> =20   Hired    =3D {^1920/01/01}<BR> =20   Salary   =3D $999.95<BR> =20   Age      =3D 93<BR> =20   Weight   =3D 184.25<BR>    Inactive = =3D=20 .F.<BR>    Pets[5]  =3D .NULL.<BR> =20 ENDDEFINE<BR>ENDTEXT</FONT></DIV> <DIV><FONT face=3D"Courier New"></FONT> </DIV> <DIV><FONT face=3D"Courier New" size=3D2>? objectText<BR>oEmployee =3D=20 DefineObject(objectText)<BR>SET STEP ON && check=20 oEmployee<BR>RETURN</FONT></DIV> <DIV><FONT face=3D"Courier New"></FONT> </DIV> <DIV><FONT face=3D"Courier New"=20 size=3D2>*------------------------------------<BR>FUNCTION=20 DefineObject<BR>  LPARAMETERS objectText<BR>  IF=20 GETWORDNUM(objectText,1) <> "DEFINE" THEN<BR>    = RETURN=20 .NULL.<BR>  ENDIF<BR>  anyObject =3D = CREATEOBJECT("EMPTY")<BR> =20 linesCount =3D ALINES(objectLines,objectText)<BR>  FOR counter =3D = 2 TO=20 linesCount-1<BR>    equalSign     =3D = AT("=3D",objectLines[counter])<BR>    propertyName  = =3D=20 ALLTRIM(LEFT(objectLines[counter],equalSign-1))<BR>   =20 propertyValue =3D=20 ALLTRIM(SUBSTR(objectLines[counter],equalSign+1))<BR>    = IF=20 INLIST(LEFT(propertyValue,1),CHR(34),CHR(39),CHR(91)) THEN &&=20 String<BR>       propertyValue =3D=20 SUBSTR(propertyValue,2,LEN(propertyValue)-2)<BR>    &= nbsp; =20 ADDPROPERTY(anyObject,propertyName,propertyValue)<BR>   =20 ELSE<BR>      =20 ADDPROPERTY(anyObject,propertyName,EVALUATE(propertyValue))<BR> &nbs= p; =20 ENDIF<BR>  ENDFOR<BR>  RETURN=20 anyObject<BR>ENDFUNC<BR>*------------------------------------<BR></FONT><= /DIV> <DIV><FONT face=3D"Courier New" size=3D2>I love you fox=20 ;-)</DIV></FONT></BODY></HTML> ------=_NextPart_000_0008_01C356F7.16ACF390-- Tag: DBC Connection to SQL data?? Tag: 178355
  - 9
    - call refresh method on page frame?? Is there a way to programmtically call the refresh method of each page of a page frame? What I don't want to do: this.page1.refresh this.page2.refresh this.page3.refresh ... Besides, I might want to add pages and I don't want to have to worry about the code. TIA -Bruce Tag: DBC Connection to SQL data?? Tag: 178339
  - 10
    - open a dropdown combobox Is there a way to programmatically open a combobox??? Tag: DBC Connection to SQL data?? Tag: 178333
  - 11
    - VFP6&7&8: possible bug with TEXTMERGE Hello, All! I tried posting this behavior to the VFP bug report page, but I get a Page Unavailable error. I think this is a bug. If you can confirm this, perhaps Lee or one of the MVP's who hang out here can forward it to the right people. I am using the TEXTMERGE functions to merge memvars with preformatted RTF text that is stored in a table. If the RTF contains one or more spaces followed by a CHR(13), then the spaces are removed. To demonstrate this behavior, try this code. Note, I did not include any variables to merge with the text. <vfp_code> lcTest = "Here are 10 spaces:" + SPACE(10) + CHR(13) + "This is the second line." set textmerge to test.txt set textmerge on \\<<lcTest>> set textmerge to c = filetostr("test.txt") ?SPACE(10)$c && .F. </vfp_code> I was able to fix this issue by replacing spaces prior to using the textmerge features, but I find it a bit quick and dirty: <vfp_code> lcTest = "Here are 10 spaces:" + SPACE(10) + CHR(13) + "This is the second line." lcTest = STRTRAN(lcTest, " ", "!@#$QUICKANDDIRTYFIX") set textmerge to test.txt set textmerge on \\<<lcTest>> set textmerge to * now lets hope the replacement string does not exist in the preformatted RTF.... * otherwise use a function like SYS(2015). c = STRTRAN(filetostr("test.txt"), "!@#$QUICKANDDIRTYFIX", " ") ?SPACE(10)$c && .T. </vfp_code> So what do you think: is this behavior by design? -- Eric den Doop www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8 Tag: DBC Connection to SQL data?? Tag: 178332
  - 12
    - ComboBox bound to array with -ve value in BoundColumn Hi, Is it not possible to have a ComboBox where the RowSourceType is an array and the BoundColumn contains a negative value? What happens when I select an array item which has a negative value in the BoundColumn is that the text shown is blank - it works fine for the non-negative values. If this is they way the ComboBox works is there any way around it? I cannot change the underlying data which I am using to build the array. Thanks in advance, Pauline Tag: DBC Connection to SQL data?? Tag: 178323
  - 13
    - Upgrade question On MS website I find two different upgrade policies for VFP 8. One page says you can upgrade from VFP v5, 6 or 7. Another page says it must be the professional editions of v5, 6 or 7. So I called to ask and was told by two different people that I must have the professional version. I don't. I have upgraded nearly every version of FP since before it was bought by MS. Is it true that my upgrade path has been cut off? Tag: DBC Connection to SQL data?? Tag: 178320
  - 14
    - SET PATH missing ? Hi, At the beginning of my prg I have :cTemp = IIF(Application.StartMode = 0,SYS(16),Application.ServerName) lcChemin = SUBSTR(cTemp,1,RAT("\",cTemp)-1) SET DEFAULT TO (lcChemin) I distribute the exe (whith InnoSetup) At the install time, it's OK ... but when I lauch the exe, It said "unable to locate libary" (nearly) If I put VFP6R.DLL;VFP6RENU.DLL;VFP6RFRA.DLL in the directory of the prg, the program run Where is the error ? A missing SET PATH in the prg or a error in the InnoSetup install script ? Thanks -- Olivier (enlever les 3X pour la réponse) Tag: DBC Connection to SQL data?? Tag: 178295
  - 15
    - Issuing "MODIFY CLASS" programmatically... How can I manipulate the formset that gets generated as a result of this? I can't seem to close it, hide it, or anything much at all in fact 8-( Any ideas? Regards Mark -If more of us acted more sensibly, d'you think Governments might join in? Tag: DBC Connection to SQL data?? Tag: 178292
  - 16
    - Compiling a Class Library Hi everyone, I am trying to create a compiled version of a class library and the only way to do it was by opening the class library as a table and then replacing the "METHODS" field for all records with a blank (""). The class library was created in VFP7 and it is not a part of an executable file. Has anyone else been able to create a compiled version of a class library using another, better approach? Thanks for the help! Mehmed M. Tag: DBC Connection to SQL data?? Tag: 178290
  - 17
    - How to customize the size of paper on report ? Hi, I have a problem with my report. How to make a report (customize it's paper) if I want to use it in continuous paper which is have size: 2500 mm x Length 1400mm each sections ? Do I have to change the paper size in paper size printer properties in windows control panel ? But if I use it, in Windows XP there is no custom paper size. As information, I use Epson LX 300+. Thanks a lot for the information, teach and help. Tag: DBC Connection to SQL data?? Tag: 178280
  - 18
    - MessageBox with checkbox - API? Hi, I'm looking for a messagebox replacement for VFP7 that will allow me to display a checkbox along with the other standard messagebox capabilities. I found this one: http://www.gipsysoft.com/messagebox/ But it requires passing a pointer to a memory location as part of a structure that is passed to the DLL. I've downloaded the heap class from UT, but would rather not delve into that if there's a better alternative out there. Note: I initially rolled my own VFP class to handle this, but found that since it's a VFP form also, it's causing undesired events to fire (calling form's deactivate, if called from grid, it's when fires when dialog dismissed, etc.) So, I don't believe a VFP form will give me what I need. I also rolled my own to invoke a VFP form via COM, but it invokes very slowly and seems to block repainting of the underlying form when moved. I really appreciate all your help. Best, Mark Nadig /\/\/ Tag: DBC Connection to SQL data?? Tag: 178275
  - 19
    - FPD 2.6 printing from WinXP? Does anyone know how to get FoxPro for DOS 2.6 applications running under WinXP to print? Thanks, Jeff -- Jeff Grippe Hilldun Corporation Tag: DBC Connection to SQL data?? Tag: 178263
  - 20
    - MSComm32 and Terminal Server I have a VFP barcode app which works fine sending serial data over a normal LAN via MSComm. I'm trying to do the same thing over terminal services (XP client/2003 TS server) with serial port redirection. It's weird because the InBufferCount property gives the correct number of bytes read, but the Input property has nothing in it - in fact it's listed in the locals in the debugger, but doesn't even have a type, let alone any data. I get an 'undefined' error for the property when the OnComm event fires. I've tried just scanning into hyperterminal, and that works fine. I'm working around this using a keyboard wedge instead of serial input, but it's not ideal because I want to send a signal back to the scanner to indicate that the data has been fully processed. Any ideas? Thanks. --- Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 Tag: DBC Connection to SQL data?? Tag: 178262
  - 21
    - Default Values When changing indexes or fields, we programmatically check the status of the field or index before making the change at the user site. This way the code isn't being run each time. Does anyone know of a way to programmatically check to see if a field has a default value set. Tag: DBC Connection to SQL data?? Tag: 178258
  - 22
    - XP Embedded Has anyone messed around with XP Embedded? I have POS software written in VFP, and it'd be cool to be able to use an embedded OS - and although MS's site says that Visual Studio apps can run on XP embedded - it neither mentioned nor excluded VFP, so I was wondering if anyone has had success making a VFP app run on XP embedded? I know that VFP can't run on CE embedded (AFAIK), but XP embedded is supposed to be almost as capable as the full blown XP pro.. Tag: DBC Connection to SQL data?? Tag: 178255
  - 23
    - child table records Is there a way to make a grid (or browse) display only certain records exactly as though it was a child table in a relation (without having a parent table!) ? (I know I can set a relation from a parent, but in this case I need to simulate the relation in the child table). THANKS Mike Farnesi Tag: DBC Connection to SQL data?? Tag: 178252
  - 24
    - RecordSource property of grid I have a problem with the recordsource property of a grid. I'm using a SQL statement in the Load method of a form. I have a grid on the form with the recordsource property set to the alias that's created with the SQL statement. The problem is when I add a new record to the table that the cursor is created from. After I add the record, I rerun the SQL statement to update the cursor but then the grid shows all white. It doesn't show any of my column or row lines or any of the records. After running the SQL statement, I've browsed the cursor and all the records are in there, including the record I just added. Why doesn't it update my grid? Thanks for your help. Doug Tag: DBC Connection to SQL data?? Tag: 178238
  - 25
    - Setting views properties programmatically Hello. Does anyone know if it is possible to automatically set views properties (filtering, grouping etc.) in Outlook/Exchange? If yes, how do I do it? Thanks, Rolf Falnes rolf.falnes@tietoenator.com Tag: DBC Connection to SQL data?? Tag: 178235
- Next
  - 1
    - Is it already running? Hello All, I need to deploy an application on an NT 4 server that gets launced when certain events occur. I don't want the program to launch if it is already running, however. Does anyone know of a way to accomplish this? Is there a way to check to see if the program is already running and then exit if it is not? Thanks, -- Jeff Grippe Hilldun Corporation Tag: DBC Connection to SQL data?? Tag: 178228
  - 2
    - Seek positions pointer incorrectly VFP5 SP3 Can anyone explain why a seek should position the record pointer incorrectly ? Table is buffered (5) and tableupdate has been issued since last changes which included append blank. In the test case the pointer is pointing at the required record (record 2) such that the key fields (regno + event_no - both character) give ? regno + event_no = lcSrchVal returns .T. then ? seek(lcSrchVal) returns .T. but pointer has moved to record 1 and ? regno + event_no = lcSrchVal now returns .F. Any ideas why ? TIA, Mike. Tag: DBC Connection to SQL data?? Tag: 178221
  - 3
    - How to customize paper size in report ? Hi, How to set-up size of paper if we want to running report on perforated continuous paper with the size: Width: 2500 mm x Length 1400 mm each section. In windows'98 I set it up from printer setting " Epson Lx- 300+ properties, go to paper then custom 2500 x 1400 mm (and worked). But In Windows XP there is no paper custom setting. How to do that in XP, or are there way out to customize paper size from VFP 8 ? Note: The perforated paper size is : Width: 2500 mm x Length 1400 mm. Thank's alot for your kind help and attention. Tag: DBC Connection to SQL data?? Tag: 178218
  - 4
    - Visual Foxpro 3.0 problem with 512M memory Hello, I'm running Visual Foxpro 3.0 on Window 2000 with 512M memory. It prompts "Insufficent memory" when execution. Any idea why and how to resolve it ? Thank you Tag: DBC Connection to SQL data?? Tag: 178214
  - 5
    - SQL and Record Locking This is another query concerning converting my app to multi-user. I am using VFP 6 build 8492 (SP 3?). How do you ensure update integrity in *hybrid* xBASE/SQL code? In xBASE, I know more or how to handle the locking, but I do not know how to do it in SQL. Is it just begin/end transaction? How do xBASE and SQL commands interact? Pointers to the docs or even better to Hacker's 3 or Hacker's 6 would be quite appreciated. I think that I would prefer to avoid using a .dbc if I can. Is this viable? If not, how does one send a complete set of data to another (as when I have to debug a situation)? Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: DBC Connection to SQL data?? Tag: 178213
  - 6
    - Remove classes from memory? Tricky problem: I'm creating a framework. One of its components is a form manager class, based on the Custom class. My form manager class has an OpenForm() method. The OpenForm() method can accept a form name and some optional parameters, and it will open the named form, whether it's a .scx requiring "DO FORM..." or a .vcx or .prg class requiring "CREATEOBJECT()". All forms in the framework are based on a form class that contains code in the Init and Destroy methods to register the form with the form manager when the form is created and unregister it when it's destroyed. All of this works great while my program is running. I can create and destroy forms with no problem. And the program shuts down fine, leaving no visible trace. Until... If I run my uncompiled program in the VFP IDE, and my form manager opens a form using CREATEOBJECT(), then after my program shuts down I'll get a "Remove classes from memory?" dialog when I try to open my base form .vcx library in the Project Manager to edit a class. If I run the same program as a compiled .exe, and my form manager opens a form using CREATEOBJECT(), I don't have any problem opening the .vcx afterwards. The only way that I can stop this from happening in the IDE is to issue an explicit CLEAR CLASS [class name] command, for the class that was opened using CREATEOBJECT(), at the very end of the program, just before it shuts down. Obviously, in a production environment this is not good, because I'd have no sane way of knowing which classes had been instantiated with CREATEOBJECT() and I'd have to loop through all the records in all the .vcx files, and parse all the .prg files, to get all the class names and issue CLEAR CLASS for them, before shutting down. Please note the following: 1. This problem does not occur when the framework invokes DO FORM to open a .scx that is based on a .vcx class. 2. This problem occurs whether the class being instantiated is in a .vcx or .prg file, and whether it's based on my base form class or a subclass of that class. It is not dependent on any particular class; it occurs for any use of CREATEOBJECT() to open a form. 3. I've tried SET CLASSLIB TO and SET PROCEDURE TO at the end of my program and this doesn't solve the problem. SET("CLASSLIB") and SET("PROCEDURE") both return an empty string, but the problem doesn't go away. 4. RELEASE ALL at the end of the program doesn't help either. On the other hand, RELEASE ALL doesn't actually seem to release all--the handful of PUBLIC variables that my main program sets up are still there in a DISPLAY MEMORY even after issuing RELEASE ALL. 5. CLEAR MEMORY also doesn't do it. 6. Issuing CLEAR CLASS [class name] from the Destroy() or Unload() method of the problematic class does not work. It doesn't cause an error, but it doesn't CLEAR the CLASS either. For the CLEAR CLASS to work, it has to be issued at the very end of the program. 7. My form manager STOREs .NULL. to all form reference variables when the forms are destroyed. 8. And the program shuts down fine--nothing left in the Task List, and the class library that contains the form manager class can be opened with no problem after shutdown. To me, this implies that there are no dangling object references. I think CLEAR ALL would solve the problem (it does in the Command window), but I can't issue CLEAR ALL anywhere inside my program, not even as the second-to-last line, just before QUIT. If I do, then, due to VFP's perplexing event sequence (which doesn't actually release objects at the moment when their Release() methods are called or when a RELEASE command is issued, nor does it actually destroy objects at the time when their Destroy events occur), something or other that is dependent on some memory variable can't actually finish releasing, and I get a cascading series of errors. (Yes, I've read the help on that. Since my program works fine as long as I don't issue CLEAR ALL, do I really need to care about this? Should I really have to expect to issue CLEAR ALL in order to ensure that what SET CLASSLIB TO is supposed to do actually gets done?) I've deliberately kept a lot of detail out of this post. I CANNOT reproduce this problem in a simple scenario outside of my framework, which leads me to believe I've made a mistake somewhere, but I can't find it for the life of me. On the other hand, since the problem doesn't occur in a compiled .exe, do I really have anything to worry about? I'd be glad to post more code--even the whole project in a zip file--if someone would like to take a look at it. I'd appreciate the benefit of your experience. Thanks in advance. Ken Dibble Southern Tier Independence Center Tag: DBC Connection to SQL data?? Tag: 178209
  - 7
    - Re: VFox link with MS Word Hello, I have a request for the Vfox link with MS Word, anyone can suggest me how to do? Since I have no idea to work with it, actually they just want to use the program as a Filing System to type the Letter and Fax. But the Vfox only provide us a Memo and it doesn't have any function like a word to change the Font, indent, border and etc. Please tell me how to do if anyone have related experience, Thank You Very Much ! Wingo Tag: DBC Connection to SQL data?? Tag: 178208
  - 8
    - Dymo Labels Problem Hello Everyone, I've created few labels in different formats in VFP6.0 under WIN 2000. After upgrading to Win XP and to VFP7.0 all my labels don't work. All of them appear on size of Address label 30252. I am changing size of the label to 30334 or 30333, saving and closing it. But when I am openning it label size comes back to Address label 30252. How can I solve this problem? Why it happens? Thanks a lot, Natella Tag: DBC Connection to SQL data?? Tag: 178206
  - 9
    - c5 with CR9 - HELP! Hi Everyone, I'm having problem after problem migrating from CR 8.5 to CR 9.0 and Crystal technical non-support is batting 1000. My latest can be reproduced with a code snippet from Craig Berntson's "KB014: Integrating Crystal Reports with Visual FoxPro" (great article by the way, I'm going to order the book) at http://www.craigberntson.com/Articles/kb014.htm ================== LOCAL oCR AS CRAXDRT.Application LOCAL oRpt AS CRAXDRT.Report oCR = CREATEOBJECT("CrystalRuntime.Application") oRpt = oCR.OpenReport("i:\crtest\crtest.rpt") IF oRpt.HasSavedData oRpt.DiscardSavedData() ENDIF oRpt.PrintOut() ================== The first time the .PRG runs, everything is fine. After that I get: "OLE exception error: Exception code c0000005. OLE object may be corrupt" on the OpenReport line. If I close and restart VFP, the .PRG will print once, then fail every time after that until VFP is shut down. Can anyone else reproduce this? Is there a work-around? I've sent Craig a copy of this message in the hopes that he's not too busy to take a look. Thanks. -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ The secret to creativity is knowing how to hide your sources. - Albert Einstein Tag: DBC Connection to SQL data?? Tag: 178204
  - 10
    - one-to-many form..... need more than 2 tables Hi, When I create a one to many form it allows only 2 tables in designer mode. I add a third table and grid to link to the parent table creating the relationship. It displays and goes through the data correctly until I try to add a record. The add function only acknowledges the grid & table created using the wizard. Also any way to stop it asking the question of parent or child and always just allowing both? Any help appreciated.. Steve Tag: DBC Connection to SQL data?? Tag: 178201
  - 11
    - FoxPro 6.0 with Windows XP Anyone know of any reason I cannot install and run Visual Foxpro 6.0 on Windows XP? Thanks, Sam Tag: DBC Connection to SQL data?? Tag: 178194
  - 12
    - HERE MAKE MONEY FAST AND EASY!!! Hello amigo(a)s.. First that all I ask it excuses by sending him this message without ustéd have requested it me, I know that its time is worth gold but I assure it that if reads this letter, the time that invest in her itself edge a great deal more than well rewarded. Something as well as to receive in few weeks some OR$S 15,000.00!!! Fast Money****************** It wants to gain quick and easy money? If is thus, please, continue reading. This really functions. It is the way more jousts and honest to be able to gain some money extra without investing barely nothing. INVEST 5 MINUTES OF ITS TIME IN READING THIS AND CHANGED ITS LIFE. Internet has grown, and is growing constantly. Its size is duplicated each 4 months. It be chirped that if sees each time with more asiduidad this type of news, is because functions. It given that are more the positive points that the negatives. Are only $5.00 Dollars. Swims but! One it is spent more any tomorrow in the breakfast and the gasoline to go al I work. So I decided to send those five dollars, and al to write this letter I am sending for mail the 5 envelopes, and putting this announcement in the News. Many skeptics can think that is a deceit. THINK IT FOR A MOMENT! ... There is so many new subscribers to Internet - of the entire World - without counting to the large suppliers of E.E.U.U., they will be interested and they will cause they will function it for the simple thing of the system. I have here the testimony of persons that functioned them: Henry Toy of San Francisco: I wrote after 2 weeks to place the announcement in Internet, and envoy the $5.00 Dollars, I began to receive money by mail. It it could not believe. Al principle were only some hundreds of dollars. A week later some thousands of dollars, suddenly ¡¡ BOOOM!!!, at the end of the quarter week, I received near $47,000.00 dollars!! They came from all parts of the World. Each hundredth one is perfectly legal and the best of all is that I could pay all my debts, and I remain money for some holidays with my family. Did not only it function for me, gave result also to other persons. Markus Valppu says that he managed to join $57.883 dollars in four weeks. Dave Manning $53.664 in the same time. They give Stepstone $17.000 in two weeks. I know to some of these individuals? Not, but when I read how had they achieved I was done it myself logical. So much is so I decided to take the same risk and to invest $5.00 dollars. Is not a great risk in exchange for the potential that can have to change. That it is all the capital that invested Henry, Mark, Dave, Give,..., and even so its 5 dollars produced thousands of dollars to each one, in a way sure, without risks and totally legal. Thus is how functions in 3 simple steps: STEP NUMBER 1: Invest its 5 dollars, writing its name and direction in five leaves with the legend " please add me to its list of mail ", (please add me to your mailing list) in English and Spanish together with the dollar, of this way is not giving a dollar to someone. It is paying for a completely legal service). Wrap each dollar with role carbónico in each sheet of paper that wrote its name and direction, putting in air the envelope being assured of hitting it with a pegamento strong and envíelo by mail to these five directions: (a dollar to each direction) 1. Luis A. Carranza Obese Cienfuegos, 186 Urb. The Mercy Trujillo - PERU 2. Fortune Rodriguez Garcia Crta. Caravaca, 30 30440 Moratalla Murcia - SPAIN 3. Enrique Moral Colliure, 31 2º 1ª 07010 Palm of Majorca Balearic islands -SPAIN 4. Ricard Palm i Adsuar Plaza Father Claret,3 08650 Sallent Barcelona - SPAIN 5. Miguel C. Zavala Yáñez Calle Genaro Sanginéz #863 casi esquina catacora, Último timbre de arriba Tel-2284506 La Paz - Bolivia STEP NUMBER 2: Now eliminate the #1 of the list, and travel through the other names up, so that the #2 be the #1, the #3 be the #2, etc., and put its name and direction in the #5 of the ready Osea should copy this article of principle to end such as is, unicamente should eliminate the direction Not 1 of the upper list putting the direction Not 2 where was1, the Not 3 where it was the Not 2, the Not 4 where was the Not 3, the Not 5 where was the Not 4 asi all travel through a booth up remaining the booth Not 5 blank so that alli write the its as the others. STEP NUMBER 3: Publish I articulate this in at least 250 groups of news. There are at least 20.000 groups of news in any hour of the day. In as many as more groups be announced, more people will see it and more money will receive. STEP NUMBER 4: Now is when begins the business for you. It will begin to see results among the next 7 to 14 days. Recall that the Internet is in constant growth. There is not possible way to lose. ********************************* Now I will tell It as and reason the system functions: Of each block of 250 publications that does, receives 5 answers. If, only 5. With that earns $5.00 dollars in cash, not checks neither orders of payment, but hard cash with its name and direction in the #5 Each person that send it $1.00 dollar publishes its letter in 250 groups with its name and direction in the #4, that is to say, 1000 announcements. On the average, they will send it $1.00 dollar 50 persons. This are $50.00 dollars. Now you are 50 persons are announced in 250 groups each one with their name and direction in the #3, that is to say, 10.000 announcements, of which on the average they will respond 500 persons, that is to say $500.00 dollars more. Those same 500 persons are announced in 250 groups each one with their name and direction in the #2, that is to say 100.000 announcements of which on the average will respond 5.000 to $1.00 dollar each one, that are $5.000 dollars in cash. Al final 5.000 persons are announced in 250 places each one with its name and direction in the ·1 and will obtain $50.000 dollars before leave of the list, only to an average of the 1% of answer of its letter, is fabulous. Only in a cycle, will average $55.000 dollars. Only to a performance of a 1%, is simply fabulous!! When do not see its name in the list, take the last announcement, and begin again if desires. The final result depends on its PERSON. It should continue this article and to announce it as many times be able and where be able. How much more be announced, more money will arrive it for mail. It is too much simple and simple as to leave passing this opportunity!! IF NOT THIS COMPLETELY SURE one, OR THINKS THAT it can NOT be CARRIED OUT, do NOT DO IT. BUT PLEASE, PRINT THIS I ARTICULATE AND you PASS IT SOMEONE THAT REALLY NEED THE MONEY. GENERAL STEPS FOR AUTOMATIZAR THE PROCESS: Do all the necessary steps to change this article and to announce it as is explained in the STEP NUMBER 2, and when be satisfied, record it in format. txt to import it in the body of the program of the reader of news (example: Internet News). Of this way only will have to change the name of the group or direction of mail to distribute it. Important counsel: It is important for those done not very familiarize with the E-MAIL. For all the media utilize a processor of texts to be assured that the article it véan clear and correctly. Reformatear this article with a simple publisher as "Notepad", 0 "WordPad" if utilizes Windows 95. Try that the text be clearly visible and do not be necessary to move to the right to read it. To do it of this forms assures that the article will be seen well in all the readers of news. It can verify it with its reader before being connected in line, reading it in its own reader. Begin to seek immediately the groups of news where thinks to announce. Netscape 3.0 is a very good reader, for which can select several dozens of groups at the same time, permitting him to distribute his I articulate to thousands of places in less than one hour or two. He select all the groups where he want to send the I articulate. Of this way various groups in a past can be selected, perhaps a dozen each time. After that it will see the groups selected in the field of groups. Later select its group of news and press "To News". Try to put a regular adequate one in the Theme, then press in aggregates ( "Attached"), where another window will appear. Locate the file that desires to send, press the file, open it and later envíelo, . and already is! Repeat this process time and again selecting of 10 in 10 the groups, select the of greater affluence and do not announce this I articulate with very grandiose titles as" gain millions of dollars in two days" that only scare away to the people, but bién describe the title as DESCENDING THIS FILE AND LEO AS CAN RECEIVE MONEY BY MAIL, or tambien DO MONEY RAPIDO or well AQUI MONEY FACIL or anyTo the people. This it is a legitimate and honest way to do money regularly. But only it will be thus if the message is sincere and clearly understood by the others. Only thus it will achieve the success desired. AS HANDLING THE "NEWSGROUPS" Not. 1 you do not need to edit again all this letter to do the its own. Only put its cursor al beginning of this letter, do click, leaves it pressured and descend it to the end of the letter and lárguelo. All the letter should be "sombreada". Then do click in "Edit"(Editar) above its screen, here select "Copy"(Copiar). This it will do that all the letter remain in the memory of its computer. Not. 2 Open a new blank page and carry the cursor al start. Pressure "Edit" and of the menu select "Paste"(Pegar). Now it will have this letter in the "notepad" and will be able to add its name and direction in the place #6 continuing the instructions of more higher than. Not. 3 Record this letter in its new file of the notepad as a. txt file. (File of Text). And each time that want to change something will be able it to do. FOR THE ONES THAT HANDLE NETSCAPE Not. 4 Inside the program Netscape, go to "Communicator" and select "Group of news", then go to "File" and to select "to Subscribe". In seconds a list of all the "Newsgroups" of its "server" will appear. Do click in any newsgroup. Of this newsgroup do click under "TO NEWS", which should be up, in the extreme left of the page of newsgroups. This it will carry to the box of messages. Not. 5 Fill this space. This it will be the title that will see all when they travel through for the list of a group particularly. Not. 6 Mark the complete content of the file and copy using the same previous technique. Return al Newsgroup "TO NEWS" and you are creating and empastando this letter inside its program or "posting". Not. 7 Pressure "send" that is in the upper part left. And you. It HAS FINALIZED WITH ITS FIRST one! ...FELICITACIONES!!! THE ONES THAT USE INTERNET EXPLORER STEP Not. 4: Go al Newsgroups and select Post go Article". Or in they Classified select "to put an Announcement". Or in the Forums of Discusion, etc. STEP Not. 5: Copy the article of the notepad and peguelo in the place of the text that is going to send or to announce. Utilize the same previous technique. STEP Not. 7: Pressure the button "Post", "to Send" or "to Put", etc. THAT IS ALL! What it has to cause is to become in different "Newsgroups" and empastarlos, when already have practice, alone will take it some 30 seconds by each newsgroup! **REMENBER, AS MANY AS BUT NEWSGROUPS OBTAIN, BUT ANSWERS (AND MONEY) RECEIVE! BUT SHOULD ENTER AT LEAST 250** ALREADY THIS! !!.... *************** Another system to be communicated is obtaining private e-mail of persons, should be, al less, 250 as a minimum. This has an effectiveness from among the 5% al 15%. The form but easy to do it, is to seek boards of directors of e-mail, that appear in Internet. If you want to contact with persons that speak Spanish or close to yourself seeks by latin american surnames and / or in your same region, country or continent. *************** NOTE OF REQUEST: The system is bases on that all we be honest, but is too much tempting not to be bothered in sending for mail the envelopes with the bills of 1 dollar inside. The success of this programs depends if is carries out and distributed in a 500%. The system will neither function if the people takes advantage of ustéd and does not continue the instructions. If it desires to remain in the anonymity, can use a pseudonym, being assured that direction is the correct one. *************************** Note: This is a service and a product 100% legal (Defined in US Postal & Laws of the lottery, Regular 18, Sections 1302 and 1341 or Title 18, Section 3005 of the American Code, and also in the Federal Code of Regulations, Volume 16, Sections 255 and 436, Which establishes that a product or a service should be exchanged with money received.) ************************************************************* FINAL NOTE: Many of the ideas to do money, it does not matter that so well planned and implemented simply itself do not raise. And in many of the cases due to the costs of publicity, but the publicity obtained by Internet is honestly very impressive. So, please, study I articulate this meticulously and be taken the time that want, since when decide to participate, will be underway to receive important quantities of money. By the same nature of this system, will not see the results the first week, but from the second, ITS INCOMES BY ORIGINATING MAIL OF THE ENTIRE WORLD ARE GOING TO SURPRISE!!!. Please, this it be chirped seriously because is one of the few opportunities to do quick money that really functions. GOOD LUCK!! BUENA SUERTE!! Tag: DBC Connection to SQL data?? Tag: 178190
  - 13
    - take a picture of customer Hello again all you helpfull fox type people out there. This weeks project is to hook up a web cam to the terminal acting as a POS system and snap a picture of the customer and clerk when the cash,check,charge button is pressed. I was thinking of hooking up one of them little logitec ball type webcams, but havent taken step 1 yet. My question is; Has anyone done this already and if so how? Glen Tag: DBC Connection to SQL data?? Tag: 178186
  - 14
    - Where to get VFP8 Anyone have suggestions on where to get VFP8 (upgrade)? Tag: DBC Connection to SQL data?? Tag: 178183
  - 15
    - NUll dates in Crstal Report v9 (OLE DB and VFP 8) I hope someone can answer this for me. Null date values in a report field shows it as 12/31/1899. Please help! Thanks. John Tag: DBC Connection to SQL data?? Tag: 178181
  - 16
    - Import TXT How can I import TXT files into FoxPro? Thanks Tag: DBC Connection to SQL data?? Tag: 178179
  - 17
    - Moving VFP6 app to VFP7 Hi all, I'm trying to compile a project that was originally built in VFP6 in VFP7. About the time it would normally be done, I get a "Compile Error in C:\MyPath\MyFile.app". I've converted the menus to 7.0 format. Any other ideas as to where to look? If it is menus, I do have one or two prg-based shortcuts that have not been touched. TIA, John Tag: DBC Connection to SQL data?? Tag: 178177
  - 18
    - =?iso-8859-1?Q?Error_reading_file=22_error__number_1104?= I've been getting an "Error reading file" error number 1104 on workstations running windows XP PRO. It happens intermittently, but when it happened it usually does upon execution of the calculate command. The other day I got the message when I issued a seek() on a table. The applications is running on a network with Windows 2000 server with service pack 1. The other workstations are Windows 2000 service pack 3 and don't seem to have this problem. I wonder if this is Windows XP problem or if I should switch to a different type of file sharing schema. Since only a few users access the system at any one time I currently use the following settings: SET MUTILOCKS ON SET REPROCESS TO Perhaps I should switch to a table buffering system. Thanks for your help. Tag: DBC Connection to SQL data?? Tag: 178168
  - 19
    - Replacing tables in a database Because a client does not have a copy of VFP, I emailed myself a table which needs to be reindexed. (Adding a reindexing function to their software is high on the list!) If I open these tables at my office, reindex them, then simply overwrite the tables at the client's site, will the database container somehow be offended? :) Or will it relatively seemlessly reintegrate these files into the container even though the files themselves were last opened outside the container? VFP 6. TIA. -S- Tag: DBC Connection to SQL data?? Tag: 178167
  - 20
    - Unwanted classes and files. I have a project under construction which uses a base class and a second class, for the project only, based on the base class. The base class is common for several apps. There are various forms based on the second class. I find that, when I build the app, it includes an old class which has no relevance (and is in a different folder) and some old forms based on the old class which also are unwanted. I have checked everything I can think of for reference to those and can find nothing. Nevertheless, when I remove them from the project and build it again, they reappear. Any ideas please as to what is going on and how to correct it ? -- Tim Hobson Tag: DBC Connection to SQL data?? Tag: 178153
  - 21
    - Command line parameter opening a databse I have two programs and I need program A to call program B. Program B will then open the same database that program A is using. To do this I implemented a command line parameter in program B that will open the same database. If I try to run program B from say run in the start menu and put the name of a database for the parameter everything runs fine. But if I try to run it from program A I get an error. The code is RUN /N B.exe "c:\Database\database.dbc" Note that this is an example, the database will actually be a string variable When I try to call an Open Database on the parameter, it does not open and then I get an error when I try to do something saying "No Database is open or set as the current database." Tag: DBC Connection to SQL data?? Tag: 178150
  - 22
    - Passing arrays I have a procedure and I need to pass an entire array from another procedure. How I can do that? Regards. Tag: DBC Connection to SQL data?? Tag: 178142
  - 23
    - Different print layout in Win98 and W2k Hi, I use VFP6 on W2k to do development. Some of my client's OS are Win98 while some of them are W2K. However, it is found that the print layout in Win98 and W2K are difference. While the print layout is suited in Win98, it is not suied in W2K, or vise versa. Can anyone give advise?? Thx billion. Yan Tag: DBC Connection to SQL data?? Tag: 178131
  - 24
    - Updating accName property for IAccessible objects programmatically We are trying to get our VFP7 application to work with a screen reading program (for the visually impaired). That program (JAWS) uses MS Active Accessibility (which VFP7 supports) to access our VFP apps screen objects. VFP7 automatically sets the value of the accName, accValue properties etc. As our form textboxes are named "txtSurname" (for example) vfp7 assigns the IAccessible property accName for that object as "txtSurname" which the screen reader speaks to the user. We would like to keep txtSurname as the object name in VFP but somehow set the IAccessible accName property to "Surname of client" (for example). Has anyone had any experience with this? The MSAA SDK looks a little daunting to me as all the doco seems to show things using C structures, definitions etc. I understand I'll probably have to use olcacc.dll to do this. Thanks for any help or advice. Andrew Grandison SA Dept Human Services Adelaide, South Australia Tag: DBC Connection to SQL data?? Tag: 178130
  - 25
    - Legal Developer Question Hi all, I have just completed a system that I want to sell, however, someone told me that my employer could claim rights to the software package. I talked to my employer and he told me to draft a legal document in which I should state that they have no rights to the software and that I am free to sell it to anyone. Does anyone have a template of such contract or can anyone point me in the right direction??? Thank you Hutch Tag: DBC Connection to SQL data?? Tag: 178127

I have already created an connection object with my DBC that I use with
remote views into SQL. If I want to query a table in the SQL server, can I
use the connection object I have already created?
I tried:
sqlconnect('mydsn','myusername','mydbcconnectionobject') but it doesn't
work.
I'm trying to limit the number of times I have to put the username and
password in code.

TIA
-Bruce

Top

RE: DBC Connection to SQL data?? by Leemi

Leemi
Thu Jul 31 16:44:43 CDT 2003

Hi Bruce:

Since you are trying to limit the number of times the login dialog appears,
can you try the suggestions in this article?

187720 HOWTO: How to Disable ODBC Login Prompt at Run-Time
http://support.microsoft.com/?id=187720

I hope this helps.

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

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- 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 retires June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003

>I have already created an connection object with my DBC that I use with
>remote views into SQL. If I want to query a table in the SQL server, can I
>use the connection object I have already created?
>I tried:
>sqlconnect('mydsn','myusername','mydbcconnectionobject') but it doesn't
>work.
>I'm trying to limit the number of times I have to put the username and
>password in code.

>TIA
>-Bruce

Top