ADO in EXE / DLL

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
    - FPW2.6a genxtab output field order? Maybe I should just give up with this program but having got it to actually do something [which has wasted most of the day,] I now find I don't seem to have much control over the order of the field names it generates. I have twelve months of data from 05/2003 to 04/2004 (May 2003 to April 2004 respectively.) I want the fields in chronological order from left to right. I know I can rename them in yyyymm format and then it will work because genxtab assumes you want them in ASCII order left to right. Is fiddling the name of the fields the only way? I'm tempted to patch genxtab to write out fields in the order they appear in the input data (surely more sensible?) -- TIA Andrew Howell Tag: ADO in EXE / DLL Tag: 196167
  - 2
    - VFP licencing under MSDN Below is the answer, direct from Microsoft : MSDN Universal, MSDN Enterprise, MSDN Professional and MSDN Operating Systems are licensed for single users, and can only be used by licensed subscribers. All products that ship in MSDN Subscriptions are for development and test purposes only, and cannot be used in a live production environment. This seems to infer we should not be using any VFP version shipped with MSDN for live production. Presumably a separate site licence is really required. Is that how everyone else reads this? Thanks for any comments. Bernie Tag: ADO in EXE / DLL Tag: 196164
  - 3
    - FPW2.6a cannot get genxtab to work Hello, I'm trying to generate a cross table from a query but genxtab is throwing an error "unexpected end of file encountered" Closer examination of the program seems to be the line of code APPEND FIELD (FIELD(1)) FROM xtabtemp I think this line of code is supposed to create all the row possibilities in the empty output table. It is appending blank records for me; this means when the program goes on to insert the data it cannot find the correct row. Why? xtabtemp has all the values for the different rows, I've looked up "APPEND" in the help file and there is no "APPEND FIELD" clause documented. Here is a test case: ************************ CREATE CURSOR test (period C(7), ; type C(1), ; qty N(5,0) ; ) INSERT INTO test (period, ; type, ; qty ; ) ; VALUES ('01/2004', ; 'A', ; 100 ; ) INSERT INTO test (period, ; type, ; qty ; ) ; VALUES ('01/2004', ; 'K', ; 200 ; ) DO (_genxtab) WITH 'XTAB',.T.,.T.,.T.,2,1,3,.T. ************************ -- TIA Andrew Howell Tag: ADO in EXE / DLL Tag: 196162
  - 4
    - Scan taking place from previous record;works normally in debug mod Hi All, I have a strange behaviour with record pointers within a cursor. Consider the following commands Next button click: SCAN NEXT 7 ... ... ENDSCAN Previous button click: SKIP -(number of records displayed + 7) SCAN NEXT 7 .. .. ENDSCAN I click on next to display the next set of 7 records, then I click on previous to display the previous set of 7 records and then when I click on next button again, one record from the previous page is displayed. The program behaves as expected in debug mode. Does anybody know why such a thing is happening and how it can be solved. Thanks Tag: ADO in EXE / DLL Tag: 196160
  - 5
    - Finding the beginning of the result set Hi All, I have stored the result of a query in a cursor. My program is such that I need to scroll back and forth in the result set. How can I at any point of time, check whether, I am at the beginning of the result set; so that I don't try to scroll before the beginning of the file? if cursor_name.bof() .. .. endif cursor_name.bof() is giving an error - Object cursor_name not found! Any suggestions to solve this problem would be greatly appreciated. Regards Tag: ADO in EXE / DLL Tag: 196153
  - 6
    - Newbee Questions Hi I am fairly new with Visual Foxpro V6.0 having done most of my programming in C++, VB and delphi. I am quite comfortable with VFP and the language but am having trouble with GUI side of things. I wish to have a richtext box that allows the user to change font, font size and colour I see that there there is an example that comes with foxpro in the foundation classes under text formating where it makes the desired changes to the active control but I can't see how the connection between the font toolbar and the active control is made. I have encountered this connection type problem on many of the example's that I have looked at. On the RTF control how is the text printed I have had a lot of trouble controling what I want to print in foxpro there just not seem to be simple calls to print dialogs and print type statements. Any help would be greatly appreciated. Warren warrenjw@austarnet.com.au Tag: ADO in EXE / DLL Tag: 196146
  - 7
    - CursorAdapter, Parameters sql command not working I use cursoradapter builder to build a class and compile it to a datacls.exe file. I issue the command : odatacls = NEWOBJECT( "mtn08", "Datacls", "Datacls.exe" ) odatacls.selectcmd = 'select * from mtn08 where code = ?lcmyvar' lcmyvar="ST" odatacls.cursorfill() to query a parameters sql results, the Error message show as : Microsoft OLE DB Provider for SQL Server : No Value given for one or more required parameters. How to pass the parameters into the query? Tag: ADO in EXE / DLL Tag: 196144
  - 8
    - Questions about _supermover1 in VFP class library Hello, I am trying to use the supermover from the VFP class library but I can't seem to find a way to activate it. I drop an instance of the class on my form, set up the required SQL cursor as the data, and run the form. The data does successfully get loaded on the source listbox, but everything appears grey, including the 2 listboxes, the data in the source box, and even the add and remove command boxes. I check "enabled" and it is set to .T. But I can't figure out why it's still not activated. Anybody tried using this class and can show me what I'm doing wrong? Thank you. -- jw Tag: ADO in EXE / DLL Tag: 196139
  - 9
    - Databases I have been advised to issue a set default to stmt to change the path of "training" data, that is a copy of the "live" data that a user can train and learn with. Issuing a new set default to, such as set default to c:\MyApp\Train does not change the reference in the database of the form and the form continues to use the table referenced in the form. What am I missing? Tia Tag: ADO in EXE / DLL Tag: 196136
  - 10
    - Databases I have been advised to issue a set default to stmt to change the path of "training" data, that is a copy of the "live" data that a user can train and learn with. Issuing a new set default to, such as set default to c:\MyApp\Train does not change the reference in the database of the form and the form continues to use the table referenced in the form. What am I missing? TIA Tag: ADO in EXE / DLL Tag: 196134
  - 11
    - Databases I am not able to change the "database" in a form by issuing the statement "set default to c:\MyApp\Train" When I do issue the statement, the form continues to display the original database such as c:\MyApp. Running the form continues to use the table that is part of the database that was in use when the forms DE was use at the time the tables were added to the form. Is there another way to change the forms database, or am I missing something? TIA Tag: ADO in EXE / DLL Tag: 196133
  - 12
    - Command to be continued on to the next line Hi All, If I have a long line of command which I want to continue on the next line, what combination of characters do I give at the end of the first line? Thanks. Tag: ADO in EXE / DLL Tag: 196130
  - 13
    - Questions about moving items between list boxes Hi All, I have this list boxes controls that I copied from the moverlists class in "Solution" of VFP6.0. I have the following 2 problems when moving items between the list boxes. 1. It seems I can only display multi columns for the two list boxes by setting RowSourceType to 2 or above. Setting RowSourceType to 0 or 1 makes the listbox to display only 1 column. Since I need to clear the listboxes often so I'd prefer to set RowSourcetype=0. If I do that is it still possible to set them to display multi columns? 2. If I specified RowSourceType to 6 for both listboxes, The code SCAN List.AddItem(table.field) ENDSCAN fills both (source and destination) boxes instead of only the source listbox. Anyone knows why I am doing wrong here? I am using VFP6.0 sp5. Thanks for any inputs. -- jw Tag: ADO in EXE / DLL Tag: 196125
  - 14
    - Menus, Problems & Errors Hello, I have trouble using different menus with different forms. I am using VFP 8.0 SP1 1) Main form has top level menu name 'main'. 2) Second form is MDI has menu 'order' called when form is called & release when form is release . Problem#1 with Method 1 When second form is called, Main menu is deactivated when lost focus & activated when got focus. Problem is it's change position of menu & first bar can't be accessed because of icon place from second form. Problem#2 with Method 2 When second form is called, Main menu is released using 'Release Menu " command, when lost focus & called using 'do main.mpr' when got focus. Problem is after few uses, got an error "Not enough Memory to complete this operation'. Problem#3 with Method 3 When second form is called, Main menu is released using 'Release Menu Extended " command, when lost focus & called using 'do main.mpr' when got focus. Problem is after few uses, got an error "Menu Manager internal consistency Error'. I tried all commands related to menu, but no success. Please suggest me best solutions to use different menus with different forms in one program. I wonder why menu system in VFP is so complicated, compare to VB. TIA Jit Tag: ADO in EXE / DLL Tag: 196123
  - 15
    - How to send shapes object in the container to printer? Hi all, I have an apps with an ability to draw lines. The 'drawing pad' is actually a container and the the drawing are collection of shapes that each has specific length, top, left, and width properties. By saving those values on tables, my apps can save and open the drawing. The shape objects has several proprietary properties that are used for specific calculations, the drawing is just used to somehow visualize the entry. Problem begins today when my clients asked me to upgrade the application such that he can print the drawing. Question: Any idea how to send the drawing (which are actually shape objects in the container) to printer? TIA, Willianto Tag: ADO in EXE / DLL Tag: 196122
  - 16
    - Defining the dimensions of an array Hi All, Is it possible in vfp to declare an public array (so that the array is visible anywhere in the application) and then define its dimensions at a later stage (when I know what the size of the array is going to be)? Something like redim in visual basic... Regards. Tag: ADO in EXE / DLL Tag: 196117
  - 17
    - Databases I have developed an application. Now I want to add a "Training" feature that will will the same tables as the "real" application. I have a new database for the training, but all the forms have the database as the original. How can I tell each form that the database has changed from MyData to MyDataTr so that the tables in the training folder can be used with the forms that were created using the original database of MyData? In other words, is there a way to programatically change the database property within each form? Tag: ADO in EXE / DLL Tag: 196107
  - 18
    - FoxPro ODBC Driver? Hi: I am building an application with AccessXP and need to connect to a FoxPro DOS tables (v.25/v.26). The ISAM driver use A97 has been discarded in AccessXP in favor of the Microsoft Visual FoxPro ODBC driver. Can you tell me where the link is on the Microsoft site to download the VFP ODBC driver? Currently on the machine at the client site the driver is v6.01.8629.01 dated 9/21/1999 for vbpodbc.dll. His is a Win98 machine. On my machine, a Win XPPro, the VFP driver is 1.00.02.00 dated 8/29/2002. I am having a problem when I link using the old VFP driver. I have a field called Active that is type Logical (boolean). If I query the table it presents all records. However, if I filter it to all records where Active is True/-1 or False/0 no records are returned. If I create a calculated field where I compare Active to True, those that are true = -1 and those that are false = 0. However, if I attemp to filter on that field again I get 0 records. So something must be wrong with the ODBC driver on the client machine where the ODBC freaks on logicals. Any link to a VFP driver that would be more up-to-date would be appreciated. Tag: ADO in EXE / DLL Tag: 196100
  - 19
    - UDF's in FoxPro indexes I am trying to share foxPro files with Clipper apps using CDX-compatible drivers. The problem is that the index expressions include function names that are incompatible with FoxPro. Some are easy to fix - the Pad() function can be replaced with PadL() for example. However, the Descend() function allows mixed ascend/descend indexes, such as INDEX ON CUSTCODE + DESCEND(INV_DATE) TO... As you can guess, this will produce a sort order of ascending costmer codes, but descending invoice dates. I know how to reproduce the functionality of Descend() in FoxPro by creating a UDF, but I also need to know how to make sure that it is always available every time VFP8 runs - without the user having to explicitly load any procedure files. What is the best practice for this? Also, is it possible to create a DLL or something containing UDF's for index expressions athat can be attached to an ODBC, OLE DB or ADO objects so that other apps using an instance of the FoxPro data engine can also automatically have access to these functions? TIA Carlo Tag: ADO in EXE / DLL Tag: 196096
  - 20
    - UDF's in index expressions I am trying to share foxPro files with Clipper apps using CDX-compatible drivers. The problem is that the index expressions include function names that are incompatible with FoxPro. Some are easy to fix - the Pad() function can be replaced with PadL() for example. However, the Descend() function allows mixed ascend/descend indexes, such as INDEX ON CUSTCODE + DESCEND(INV_DATE) TO... As you can guess, this will produce a sort order of ascending costmer codes, but descending invoice dates. I know how to reproduce the functionality of Descend() in FoxPro by creating a UDF, but I also need to know how to make sure that it is always available every time VFP8 runs - without the user having to explicitly load any procedure files. What is the best practice for this? Also, is it possible to create a DLL or something containing UDF's for index expressions athat can be attached to an ODBC, OLE DB or ADO objects so that other apps using an instance of the FoxPro data engine can also automatically have access to these functions? TIA Carlo Tag: ADO in EXE / DLL Tag: 196095
  - 21
    - Calendar control & VFP9b I'd like the click event of the calendar ocx to update the value property of a textbox which is elsewhere on the same page. However, as soon as any code I put in the click event begins to fire, the calendar reverts to the default date, and I can only get a value for today. Guess I need a calendar control tutorial. Can anyone help? -Lew Tag: ADO in EXE / DLL Tag: 196089
  - 22
    - determine the name of the popup which will be called from the pad I'm creating a menu in the system toolbar, using the following coding, DEFINE PAD PadShortCut OF _MSYSMENU PROMPT "\<Shortcuts" COLOR SCHEME 3 KEY ALT+S, "" ON PAD PadShortCut OF _MSYSMENU ACTIVATE POPUP ShortCuts DEFINE POPUP ShortCuts MARGIN RELATIVE SHADOW COLOR SCHEME 4 Some where else, i want to PUSH the popup ShortCuts, but for this i need to know this name, It could be ShortCuts or ShortCut, or PopShortCut So, basically, given the Title of the PAD, CAN I determine the actual name of the PopUp which will be called?? Regards, Paul Tag: ADO in EXE / DLL Tag: 196086
  - 23
    - disappearing menus Has anyone experienced a situation where the pull-down menus will disappear or somewhat collapse. They get reset once the user logs-out and logs-in again. Thanks, Chris Tag: ADO in EXE / DLL Tag: 196081
  - 24
    - Contract FoxPro Programmer Available for NJ or offsite projects I am a foxpro developer for about 10 years. I was recently laid off and I am looking for any projects related to Visual Foxpro, data processing, website maintenance, and complete rewrites of legacy 2.6 apps to Visual FoxPro. I have a base of solid OOP framework based on the MEI standard that can be used as a good staring point for any new application. If you are in need, please visit my website and give me a call. Thanks Jim www.datacontracting.com Tag: ADO in EXE / DLL Tag: 196077
  - 25
    - tableupdate Hello Is there any way of finding out excacly what table update translates into. ie can i find out the sql command it generates???? any help will be appreciated regards simon haynes Tag: ADO in EXE / DLL Tag: 196063
- Next
  - 1
    - TableUpdate() Dear Sir/Madam We are using Visual Foxpro (Version 8 Sp1) and ODBC (Visual Foxpro Driver 6.01.8629.01). We have a severe problem in that when a table has more than 50 fields in it and we are doing a tableupdate() the program crashes with a fatal error: C0000005. I have noticed that this error occurs at the same point (record) as if you have done a copy to array on the table. I.e. at the point the array has reached its 64k limit. (does tableupdate() use an array - if so can this array be cleared?) We have managed to code around the error by saving each reacord after 30 fields have been replaced . Ie using TableUpdate more than once on the table. The problem with this though is that performance is decreased enormously (so much so that the software is unusable). Could you please advise on how this issue could be resolved. Regards Simon Haynes Tag: ADO in EXE / DLL Tag: 196056
  - 2
    - scroll bar for image control hi all, i am working on the project which shows the picture of toys along with its packing list and other details. The problem is some pictures are two big and cant fit into one form. therefore, i tried to change the stretch property to 1 or 2 instead of default clip so that the size of photo can be reduced and can be easily viewed. But some photos especailly the big photos after changing the property are not clear. can we not provide scroll bar or something like that. I mean to say can we drag the photo to see it full. Does image control has some property which can function like this. It will be great help as the project has been already completed and this issue has arrised now. regards gibbs Tag: ADO in EXE / DLL Tag: 196053
  - 3
    - [VFP9B]: What is the meaning of Intellisense-underline things? Hi all, Whenever I write some code and (looks like) the Intellisense is working, the text I typed is underlined. The underline eventually disappear but I cannot figure out what the underline means (it must've meant *something*) Anybody enlighten me please... :-) TIA, Willianto Tag: ADO in EXE / DLL Tag: 196052
  - 4
    - save / restore user settings Hi, Is there an easy way to save and restore "lay-out"-properties that a user has changed upon opening and closing a form. for example : grid.columns.width, form.height/width/top/left. I could make my own one but this probable already exist so if somebody....you know... thanks in advance christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`° º Tag: ADO in EXE / DLL Tag: 196051
  - 5
    - Programmitically add default values Hi. VPM 6.0b, VFP 6 I am trying to add a new record to a customer list that uses s<pre>cgpk to generate the new primary key. I have opened the s<pre>DD2 table, located the record for the table and PK field, then do a: store smsydd2.default to lcRunIt eval(RunIt) The error I get is looking for a DD2DEFAULT table. Can someone advise me on this table? Thanks, Gene Conrad Tag: ADO in EXE / DLL Tag: 196042
  - 6
    - comments for subclass Hi Experts, How to make our comments in a class appear in subclass ? I need to know parameters that is needed for DoDefault() function in a subclass without opening the class itself. Thanks a lot Tag: ADO in EXE / DLL Tag: 196041
  - 7
    - VFP 6 service pack What is the latest version of VFP 6? I ran Visual Studio Service Pack 6, but it seems not to have changed the VFP version, and no SP is listed in the About box. I see from MS's life cycle schedule that support for VFP 6 has ended. Does that mean service packs will be unavailable? -- Email to (remove spaces and make other obvious corrections): p p m b 2 0 0 4 - 2 0 0 4 at y a h 00 Tag: ADO in EXE / DLL Tag: 196020
  - 8
    - Memo 2 Command Ok i have a Memo field with some Text Information in it... this information completes a CREATE TABLE command, so I need to do somthing like this but that will work: CREATE TABLE REC03 + table.field Any Idea's? Tag: ADO in EXE / DLL Tag: 196011
  - 9
    - Grid header color and Windows XP theme In VFP 8 I have a grid that I set the headers to change color as the column focus changes. This works OK in classic windows theme but does not change color in XP theme. The grid theme property is set to .T. Anybody come accross this? ----------------------------------------------------------------- Paul Lee ........... Abri Technologies ......... http://abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: ADO in EXE / DLL Tag: 196008
  - 10
    - Query/Program Problem I am getting a Syntax error on the following code... Anyone see whats wrong? CLOSE ALL SET SAFETY OFF xFn = "REC03.XLS" xTn = " REC03" xTs = "" xTs = " (" xTs = xTs + "region c(2), hospcd c(2), filler0 c(2), acct c(11), actype c(1), acctsubtp c(1), contind c(1)," xTs = xTs + "filler1 c(1), rectp c(1), filler2 c(3), createdt c(6), filler3 c(4)" xTs = xTs + ")" CREATE TABLE + (m.xTn) + (m.xTs) SET SAFETY ON Thanks in advance. Tag: ADO in EXE / DLL Tag: 196004
  - 11
    - Creating Macros in User Apps I would like to know if it's possible to access the macro dialog box from within a visual foxpro application. In foxpro I can use SYS(1500,"_MST_MACRO","_MTOOLS") which is fine, but Tools-Macros is not available typically in an app. I've tried to define the menu using the corresponding bar#, that does nothing. I've tried calling sys(1500) from the app, doesn't work. HELP!!!! -- S. Morris System Analyst Tag: ADO in EXE / DLL Tag: 196003
  - 12
    - Release object in a procedure Hi. I have a simple problem Here's my procedure : PROCEDURE DestroyMyObject PARAMETERS TheObject RELEASE TheObject ENDPROC I tried to call it with @ but it has no effect. How can I release my parameters in a procedure ? Is it possible ? Thanks in advance for your help. Tag: ADO in EXE / DLL Tag: 195988
  - 13
    - i made an exe from my program but hi i made an exe from my program but it dont worke and i get this error message could you help me Program Error Cancel Suspend Ignore Help Error loading file - record number 3. form1 <or one of its members>. FontCharSet : Error with Form - FontCharSet : Expression evaluated to an illegal value Tag: ADO in EXE / DLL Tag: 195979
  - 14
    - finding string of one table in another Hi All, I have a table: id1 fld1 ---------------- 1 hand 2 feet 3 leg and second table is: id2 fld2 ----------------- 1 I have two hands 2 six feet under 3 last leg of his tour 4 nothing 5 these two go hand in hand How can I get records of second table THAT CONTAIN text of 'table1.fld1' in 'table2.fld2' by using SQL-SELECT in VPF7. (There should be 4 resultant records). TIA Kamran Tag: ADO in EXE / DLL Tag: 195969
  - 15
    - using double-byte character sets (DBCS) Hey everyone! I'm working on a program that takes keyboard entered words (whose letters each have an ANSI value between 0 and 255) and converts them to charcters and expressions in a given double-byte font. To do this, what I really need is a double-byte equivalent of the CHR() function. But since there isn't such a function, there must be some other way of going about it. Related to all this, when I copy characters to the clipboard using the Windows XP Character Map, they paste fine into all my other windows programs (WordPad, Photoshop) but they always paste in as "???" in VFP6 even though I've selected the display font to show the desired double-byte font. Any help would be appreciated. Scott Tag: ADO in EXE / DLL Tag: 195964
  - 16
    - MSMAPI question I did a form that try to send an email with some attachments. It works great under W98 2nd edition. In Win 2000 in some workstation it said that the class was not registered. I registered using regserv etc.. and it is not working properly I always get the same message, the class was not registered. In other WK under Win 2000 I got an error message in the following line. oform.Message1.send(1) the error was: exception code OLE dispacht 0 de MAPImessages. Unespecified failure has occurred. I do not know what to do. The aim of my program was to built a form that run in almost any environment (Win 98, 2000, XP, etc) using Outlook Express. Any advice will be welcome Thanks in advance Mariano Tag: ADO in EXE / DLL Tag: 195962
  - 17
    - Manuel for ODBC Could you suggest some manual for using ODBC. I am interested in basic concepts and how to work with MySql server... Thanks Tag: ADO in EXE / DLL Tag: 195959
  - 18
    - Playing a WAV File over a Modem We want to play a .wav file over a our PA system in the warehouse when a condition is met. I am told all we need to do is have a modem call an internal for the PA system and then play the .wav file. Does anyone have any experience with doing this. Figured I would ask before investigating this. Thanks Tom Tag: ADO in EXE / DLL Tag: 195955
  - 19
    - Tableupdate always true with cursoradapter and ado Hi, I'm using VFP8 with sp1. I'm connecting to a DBC by using an ADODB connection. Retrieving and updating data works fine. To do that i use a cursoradapter that uses the adodb connection as activeconnection. So far no problems. But when the following situation occurs, tableupdate behaves very strange: User 1 opens a record for edit User 2 opens the same record for edit User 1 updates and closes the record, the data in the record is changed User 2 updates and closes the record, because the data has changed this user should receive an update error but i don't get an error either on the recordset, the connection or with the TABLEUPDATE(1,.F.). I tried several locktypes but i cannot solve the problem. Hope someone can help me out with this. Pat Tag: ADO in EXE / DLL Tag: 195954
  - 20
    - Class Instantiating Problem I have a DLL project with two classes (Let's say ClassA and ClassB). From ClassA I want to call a method in a different class, which is also called ClassB (this is not the same ClassB that is included in the project). Now if I use NewObject('ClassB', Path of ClassB), instead of creating the ClassB from the path I specify, it creates the ClassB that is included in the project. How can I instatiate the ClassB that is stored outside this project? (I guess I did not confuse!) Best Regards, Y. Sivaram Tag: ADO in EXE / DLL Tag: 195951
  - 21
    - Universal Thread Messed Up? Hey folks, Is anybody else having a problem getting the UT message treeview nodes to expand this morning? I can't get any of them to open up in either IE or Mozilla; both browsers report Javascript errors when I try it. Ken Dibble Southern Tier Independence Center Tag: ADO in EXE / DLL Tag: 195950
  - 22
    - How can I insert data into SQL Table from vfp table(dbf file)? Hi, all, I have table named daykj in SQL SERVER, now I want to append data from a vfp native table named _daykj(locate in kjdata), I try the following code, but It seems to be uneffective. cCs="Driver={SQL Server};Server=(local);Database=zwhrp;Uid=sa;Pwd=;" nHandle = SQLSTRINGCONNECT(ccs) nStat=SqlExec(nHandle,"INSERT Into zwhrp!DayKj Select * From kjdata\_DayKj") Anyone can give me idea? Thanks in advance! Chuen Tag: ADO in EXE / DLL Tag: 195947
  - 23
    - How to send a simple HTTP request Hi all, 1- I have a small service running on my server with a little web server. All I want to know is how I can send a simple HTTP GET request to it through my form in VFP9, such as : http://127.0.0.1:8800/?ph=3774&Text=test+123 2-In the same case how can I retreive the HTTP response from the web server ? TIA Tag: ADO in EXE / DLL Tag: 195932
  - 24
    - On Label Key I need to create "Hotkeys" with "+" and "-" in my application. Is there a way to do this? They are not options in the On Key Label command. Thanks, Scott Tag: ADO in EXE / DLL Tag: 195929
  - 25
    - VFP and MySQL Hi, 1. using VFP and MySQL, does it the exe can update data in webserver from remote pc using internet connection ? eg: open table with IP address ? 2. is VFP update speed as good as compare to VB on MySQL ? Regards Hoe Tag: ADO in EXE / DLL Tag: 195926

For my 3-tier project I have created business object and data object.
Both are type MTDLL.
I use ADO for connecting to tables.
Connecting to SQL-server and VFP ( via VFPOLEDB ) works fine.

For DCOM I have to make EXE instead of DLL.
When I do this, ADO stops working.

Tips for solving this would be nice.

Rolf

Top