Databases

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
    - 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: Databases Tag: 196133
  - 2
    - 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: Databases Tag: 196130
  - 3
    - 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: Databases Tag: 196125
  - 4
    - 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: Databases Tag: 196123
  - 5
    - 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: Databases Tag: 196122
  - 6
    - 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: Databases Tag: 196117
  - 7
    - 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: Databases Tag: 196107
  - 8
    - 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: Databases Tag: 196100
  - 9
    - 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: Databases Tag: 196096
  - 10
    - 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: Databases Tag: 196095
  - 11
    - 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: Databases Tag: 196089
  - 12
    - 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: Databases Tag: 196086
  - 13
    - 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: Databases Tag: 196081
  - 14
    - 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: Databases Tag: 196077
  - 15
    - 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: Databases Tag: 196063
  - 16
    - 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: Databases Tag: 196056
  - 17
    - 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: Databases Tag: 196053
  - 18
    - [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: Databases Tag: 196052
  - 19
    - 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: Databases Tag: 196051
  - 20
    - 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: Databases Tag: 196042
  - 21
    - 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: Databases Tag: 196041
  - 22
    - 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: Databases Tag: 196020
  - 23
    - 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: Databases Tag: 196011
  - 24
    - 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: Databases Tag: 196008
  - 25
    - 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: Databases Tag: 196004
- Next
  - 1
    - 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: Databases Tag: 196003
  - 2
    - 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: Databases Tag: 195988
  - 3
    - 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: Databases Tag: 195979
  - 4
    - 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: Databases Tag: 195969
  - 5
    - 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: Databases Tag: 195964
  - 6
    - 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: Databases Tag: 195962
  - 7
    - 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: Databases Tag: 195959
  - 8
    - 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: Databases Tag: 195955
  - 9
    - 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: Databases Tag: 195954
  - 10
    - 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: Databases Tag: 195951
  - 11
    - 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: Databases Tag: 195950
  - 12
    - 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: Databases Tag: 195947
  - 13
    - 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: Databases Tag: 195932
  - 14
    - 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: Databases Tag: 195929
  - 15
    - 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: Databases Tag: 195926
  - 16
    - CodeMine Framework I'm rebuilding an application in 8.0 using the new version of CodeMine. But, the original developer didn't use, or else save, the original CodeMine environment. Has anyone any experience with this kind of situation? Thanks Steve Tag: Databases Tag: 195921
  - 17
    - can u shed some light on this weird class instantiating err Hi friends i created class (class name is ctrHeight.VCX) with container,a label ,commandbutton a textbox in it. when i add this to this a form from toolbar everything works fine. but when i add this control thr code like following thisform.AddObject('cnt','container') thisform.cnt.visible=.t. thisform.cnt.newObject('cntheight','ctrlheight','D:\VSSLocal\vip\ctrHeight.VCX') thisform.cnt.cntheight=.t. i am getting following error "Error instantiating the object "txvalue" (actually it is a textbox)" i am wondering what i am doing wrong here. i just found when i add this control from toolbar and add another control thr code like abv everything working fine??? what i am missing here?? many thanks for ideas -- cheers Tag: Databases Tag: 195920
  - 18
    - Shortcut evaluation Hi, I'm having a bit of a headache because of the following: I want to let the user type an expression and check whether it's valid or not eg "x=1 and y=2" Now, the tricky part is that I can't be sure that y (or whatever variable the user makes up) exists at this point. Now, if x equals 0, the "y=2" part is not evaluated, so I won't get an error if Y does not exist and therefor I cannot report this error (so my "expression-validation" routine will not indicate that this expression cannot be used for all values of x). Now the user can make quite some difficult statements (with brackets etc) eg: (x=1 and y=2) or ((b<=3 or c=3) and c>2) or InList(q, 'a', 'b', 'c') So my question is: does anybody have an idea about how to generate a list of all variables used in an expression? R Robert Tag: Databases Tag: 195917
  - 19
    - Moving Classes Around I should like to move my classes to another folder. How can this be done without messing-up all classes lower down in hierarchy and object based upon them? Thanks in advance. Shmiel. Tag: Databases Tag: 195915
  - 20
    - Nesting of For loops Can the "for" loops be nested in vfp? My program is giving nesting error. for i = 1 to 6 for ..... if.... ---- ---- endif endfor endfor Tag: Databases Tag: 195889
  - 21
    - compatible? Can I use Foxpro for the Web? May I create aplications, put them in an internet server and run in the usersÂ´s browsers? How does this works? -- Lorenzo MÃ¡rquez Tag: Databases Tag: 195887
  - 22
    - Assigning objects I have a situation. From container1 I am zooming into container2 by trapping the click event of container1. Both containers represent the same thing, except that container2 looks big. When I come back to container1, I want all the control settings that I had made to container2 to appear in container1 and also when zooming to container2 from container1, I want all the settings of container1 to appear in container2. What is easiest and the best way to do this? Using a base class to represent both the containers. And creating 2 objects to represent the normal and zoomed versions of the container and assigning one object to the other when zooming back and forth. Can this be done? Is this the best approach to this? Regards Tag: Databases Tag: 195883
  - 23
    - How to determine PC regional setting ? How to determine current PC's regional setting through VFP ? E.g. i have one external function call which return a value base on current PC regional setting. in order for my program to manipulate the return value, i need to know the client PC's regional setting. one common problem will be american and british date format. Thanks in advance. Tag: Databases Tag: 195877
  - 24
    - parameter for WEb Pages Hi, sorry.. this is off topic but maybe somebody can help me.... I have a very simple question, maybe a stupid one.... but I have done several excercises building WEBpages using dynamic HTML with VB scripting, and found documentation and theo bject model hard to understand :-( what I need to do is to call a web page from a hyperlink and let such called web page to receive a parameter let say that I have the following hyperlinks <P><A href="http://checaproducto.htm?product=A123">producto A</A></P> <P><A href="http://checaproducto.htm?product=A235">producto B</A></P> the idea is that for any hiperlink the same tarjet web page will be called but passing thru a parameter (product ID) my question is what kind of instruction should I need to use in the called web page (checaproducto )to know the value of the parameter(productID) I would prefer to use stadard HTML rather than ASP, is it possible? thanks thanks in advance Oscar Taboada Tag: Databases Tag: 195875
  - 25
    - Graphics in VFP In one of my applicatoins I use office automation (Excel) to display business graphics. Now this application will be deployed to a client that doesn't use MS Office. Is there any other package (e.g. Active-X) that I can use so I can keep most of the code? The graphics I produce is ordinary bar and pie charts and diagrammes. Tag: Databases Tag: 195873

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

Top

RE: Databases by Cowboy

Cowboy
Sun Jun 27 11:57:02 CDT 2004

Sorry for the duplicates. I got a message this did not post.

"Cowboy" wrote:

> 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

Top