How to get the dbc name for an open table

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
    - Field Short name editor I must support an app that exports fox2x tables to readers that don't have current odbc available, ie... they'll only be able to see the short field names. Updating the odbc drivers is *not* an option, so I'm wondering if there's a short name editor around... I know I can write one using the header info in the help file.... just trying to save some steps. Tag: How to get the dbc name for an open table Tag: 236666
  - 2
    - NYC Fox SIG meeting Thurs, Oct 4: Chaim Charon on Error Handling Looks like a good one. We meet at NYU at 6:30pm. You'll have to email me off-line for the room, though; the University hasn't confirmed yet. -Lew Tag: How to get the dbc name for an open table Tag: 236651
  - 3
    - Open Excel file in Vista You all helped me in opening a Word file in Vista so it is off the task bar. Now I have tried for a while to open an Excel File using VFP8 and have it up front. I have been trying most tricks with no luck. oWORKBOOK = GETOBJECT("C:\TEST1.XLS") oWORKBOOK.APPLICATION.VISIBLE = .T. oWORKBOOK.WINDOWS[1].ACTIVATE() This does open the file but it always ends up on the taskbar. How do you get it to open up so the user can just start using it and not have to look on the taskbar for it?? The trick you all showed me of opening word up first as 2 and then 0 worked fine for Word but how would one go about doing this in Excel? TonySper Tag: How to get the dbc name for an open table Tag: 236649
  - 4
    - GETENV("CLIENTNAME") Hey guys, we have a WinXP development computer that multiple people connect to (only one at a time) via RDP. I was thinking I could use the GETENV("CLIENTNAME") variable to see who is connected to it, but it seems to return the last user & not the current one connected. For eaxmple, if Bob connected to the computer, then logged off, when I connect to it & look at the CLIENTNAME variable it still says "Bob" istead of "Jerry". Any ideas? Or is there another way I can get that info. Note we all connect to it using the same user name. Thanks, Jerry Tag: How to get the dbc name for an open table Tag: 236637
  - 5
    - Form Memory Usage/Release Hi Firstly apologies for a long post, but really stumped. I have an application written in VFP9 SP1, backend SQL Server 2000. This runs on Windows 2003 Terminal Server, and developed on a Windows 2000 PC. We now have problems with memory usage and the dreaded "Visual Foxpro has encountered a problem and needs to close" which happens every now and again. The application allows users to open multiple forms within the _SCREEN environment. When opening and closing one screen, memory usage is OK and stable, i.e. gets allocated and released when viewed in Windows task manager with only miminal increases). However, if a user opens multiple windows (forms), then the memory usage gradually goes up and up. For example (using windows task manager) Form 1 - 15688 K Form 1 & 2 - 18756 K Close Form 2 - 17756 K Open Form 2 - 18992 K Close Form 2 - 18652 K Open Form 2 - 19016 K Close Form 2 - 18624 K So you can see, with continued use with numerous forms, the usage goes up and the application slows down. Following this, I used the Sys(1011) function and got these results: Form 1 - 3930 Form 1 & 2 - 6360 Close Form 2 - 3952 Open Form 2 - 6381 Close Form 2 - 3974 So this goes up as well. --------------------------------------------------------------------------- Now, when a form is released, surley all memory is released and allocated back. So I added a SYS(1104) to make sure but this had no impact on memory in task manager. Anybody got any ideas or pointers? Many Thanks --------------------------------------------------------------------------- Tag: How to get the dbc name for an open table Tag: 236627
  - 6
    - Any way in VFP to make sure phone line is available before dialing a fax? I am using the following code to send a fax via VFP: lo_f = createobject("faxserver.faxserver") lo_f.connect("") lo_d = lo_f.createdocument(ofile) lo_d.faxnumber = alltrim(g_fax) lo_d.send lo_f.disconnect release lo_f However, as soon as this code executes, the modem starts dialing the phone # without checking if there is dialtone or if the line is being used. I have checked my modem properties to make sure the item 'Wait for dialtone before dialing' is checked. Is there any other way to make sure that the program checks for an "available" line before dialing? Thanks Zoom Tag: How to get the dbc name for an open table Tag: 236622
  - 7
    - How to create a right-click popup menu in VFP? Hi, I am trying to create a right-click popupmenu in VFP similar to when you right-click in windows and get a menu. I want to have the menu with pre-defined user options and be able to determine which option the user clicked on. Is there any way to do this in VFP9? Thanks Zoom Tag: How to get the dbc name for an open table Tag: 236602
  - 8
    - Unable to send email from VFP Hi, I am trying to send email via VFP. I have tried ASPEMAIL and various other components. In the home machine (running Windows XP SP2), I can successfully send emails via VFP. However, at all the work computers (also runing the same OS), NONE of the email solutions for VFP work. ASPEMAIL times out and the CDO object cannot connect to server. We don't have any firewalls or other packet blocking software running. I was wondering if someone could provide a solution as to why all the emails at work computer are not able to go thru. We are a small business and have our own router and not going thru any corporate mainframe. Thanks Zoom Tag: How to get the dbc name for an open table Tag: 236601
  - 9
    - form height weirdness VFP9 SP1 on WinXP Sounds like a bug to me. Comments? Create a form. Set titlebar to 0 (off). Set height to 20. Height is 28; won't go to 20. Set minheight to any value <= 20, even -1 (it's already -1) Set height to 20; works fine. Save form and reopen. Height is no longer 20; can't be set to 20. Repeat ad infinitum. Tag: How to get the dbc name for an open table Tag: 236584
  - 10
    - Grids - DynamicCurrentControl I am trying to create a grid to work something like this: The grid would have 2 columns. The first column is always a textbox that contains the property name. The second column will allow the user to enter whatever value they wish for each property. I want to swap out the control for this second column from a textbox to a checkbox. Some of the properties are Yes/No and some are just a character field. Has anyone been able to do this? and if so, how? Thanks Dan Tag: How to get the dbc name for an open table Tag: 236583
  - 11
    - I need to find the windows fonction equal to the NOVELL Version Hi, I'm trying to upgrade some old code in foxpro 2.6 dos/win that use the NL1F25.FLL or .PLB librairy that access NOVELL Serveur. Here is the list of fonction that im trying to replace with the equivalent in windows fonction with foxpro 2.6/windows. This code is preview to be replace with a new application. But in the meanwhile im trying to eliminate the NOVELL 3.1 Server and putting all those application on a Windows servers for better hardware and access stability. Function Description NOVELL N_B_PASSWO Check if password is valid or change password N_CAPDFLT Set or query the default capture device N_CAPGET Get information about print capture device N_CAPSET Set print capture device attributes N_CAST Send a broadcast message N_CHECKF Find the station that has a file lock N_CHECKR Find the station that has a record lock N_DATE Get server date; set local station date to server's N_FULLNAME Get full name of the user logged in at a station N_INDOS Enable or disbale NetLib "InDos" TSR flag N_LOGOUT Logout and detach from a server N_MONITOR Initiate activity monitoring for a database file N_READY Ready program for network operation N_SERVER Get or Set preferred server N_STANUM Get or Set the current station number N_WHOAMI Get name of user logged in Can you help me ? Thanks Tag: How to get the dbc name for an open table Tag: 236577
  - 12
    - Error loading file Can anyone help me fix this error? The Help file is not too helpful. "Error loading file - record number 22. Text1 <or one of its members>. Methods: E:\.....InvNotification.sct is not an object file." TIA Andrew McGurk Tag: How to get the dbc name for an open table Tag: 236574
  - 13
    - Trouble between Visual FoxPro 6.0 and Flash There is a trouble between Visual FoxPro 6.0 and Flash. This trouble have become into a real challenge for me, because I couldn't have found a solution until now. If you are a Visual FoxPro developer, maybe it would be interesting for you to accept this challenge. Click on the following link to get more information about this trouble: http://www.mezarinabogados.com.pe/publicidad/problema_banner/index.htm Tag: How to get the dbc name for an open table Tag: 236559
  - 14
    - Grid resizing: 2 questions VFP 8 The following ref a grid that should always be the same size as its resizable container (ie a page or form). 1. Does the grid resize event fire automatically when its container is resized? If not, does the even fire each time any of its size related properties is updated? 2. I'm surprised to find that when I reassign my grid's height along the lines of: mygrid.height = this.height, VFP does not leave enough room for the grid's bottom scroll bar(another, slight adjust (-1) is necessary for the right scrollbar). I have to use a fudge factor of -18. Is there any way around this? and, if this is SOP, can I rely on the 18 val not to change? -Lew Tag: How to get the dbc name for an open table Tag: 236557
  - 15
    - WMI Service is Running? VFP9, Windows 2000 or Windows XP. Any safe way to determine if WMI service is running before I call something like: loWMIService = GetObject("winmtmts://"+lcComputer+"/root/cimv2" && error occurs here loProcesses = loWMIService.ExecQuery("SELECT * FROM Win32_Process")I am putting it inside of a TRY...ENDTRY but it doesn't prevent the Moniker Cannot Open File error... I am trying to determing if the service is not running, is corrupt, or if the user doesn't have the security permissions necessary to see WMI and run ExecQuery. I would like to verify WMI is running, then check for the rights to run execquery... Tag: How to get the dbc name for an open table Tag: 236554
  - 16
    - Duplex impression Hello. I need to take out 2 reports in 1 leaf, duplex impression, somebody knows as can I make it? one doesn't eat to throw the 2 reports at the same time and that the first one comes out me in one face and the second, in the same leaf from behind. Thank you. Tag: How to get the dbc name for an open table Tag: 236548
  - 17
    - help on sql-statement Hi friends I am using VFP6 I have a 2 tables has the following structure: Ledger ( table 1) --------------------- m_ac_no -primary key ( member id) a member can have more than 1 gac_no (account no) gac_no (account no. ) op_balance voucher (table 2) its a daily transaction table ------------------ vid m_ac_no gac_no vdate vtype dr cr Now I want single sql statement to get the opening and closing balance of every member (m_ac_no) or specific member account (gac_no) balance on a specifice period (x-date to y-date) output will be like : member id gacno op.ba.(opbal+(dr-cr)) cl.bal ((op.bal+dr)-cr) (opbal+(dr-cr)) 1001 101 1000 1520 1001 102 1522 2054 1001 105 1425 1020 1002 101 2541 2142 1002 105 2111 2541 and so on the op.balance will be calculated on voucher table dr and cr field (total dr -total cr) because one voucher (vid) is for one member (m_ac_no) but multiple gac_no so we have to calculate for every member(m_ac_no) gac_no total dr and cr. I hope i explain it kindly help me thanks in advance sanjib Tag: How to get the dbc name for an open table Tag: 236546
  - 18
    - FRead vs. FileToStr Does anyone know if the FRead and FWrite and other low level VFP commands are "Vista friendly?" I think the limits of FileToStr are 16 megs and I may have to process files of as much as 100 megs. Thanks, Mike Tag: How to get the dbc name for an open table Tag: 236544
  - 19
    - Error 43 - Not enough Memory to Complete this Operation Does anyone know what the resolution for this error might be. The msdn "help" is below: There is not enough memory to complete this operation (Error 43) Free some memory currently in use and try this operation again. Tag: How to get the dbc name for an open table Tag: 236534
  - 20
    - Fetching more records for a grid Hello and thanks in advance for the help... I have a grid control which is based on a small table that is extracted from a larger table. When the user scrolls to the last row, I would like to be able to requery and show the next (or previous if the user scroll up from the first record) batch of records. How do you detect all of the various method (Keyboard, Scroll Bars, Etc.) that the user might be using to scroll up from the top or down from the bottom. I could put menu items on the menu to requery but it would be more natural if they could just work in the grid. Thanks, Jeff Tag: How to get the dbc name for an open table Tag: 236516
  - 21
    - Which is faster - COPY FILE or XXCopy? I'm rewriting a routine in VFP8 (XP Pro) to back up about 4,000 small files, averaqing about 5k each, from about 5 folders from the hard disk to a USB mini hard drive. I'm considering two approaches: 1. Using XXCopy.exe with the RUN command or ShellExedute. 2. Using only the built-in COPY FILE command. I have a feeling XXCopy would be faster, but I haven't tested it. Could someone confirm that? Or is it an "it depends" situation in which case I'll go ahead and test it. Thanks for any help. Steve M. Tag: How to get the dbc name for an open table Tag: 236459
  - 22
    - Implementing events members of and Activex Using Speechlib object in VFP9 I´d instantiate it as loVoice = CREATEOBJECT("SAPI.SpVoice.1") This object has members methods which I need to use in order to highlight spoken words in an editvox. Specifically methods WORD (StreamNum , StreamPos , Pos , Length ) returns in the two last params the positions to write the statements PROCEDURE highlightspokenwords PARAMETERS pos, lenght ThisForm.MaintextBox.SelStart= pos ThisForm.MaintextBox.SelLength=lenght ENDPROC My question is : How to implement the WORD method after creating the object? Thanks Alejandro Fernandez< Tag: How to get the dbc name for an open table Tag: 236454
  - 23
    - Converting VB code to VFP (Using SAPI) This is an SAPi5.1 utility called TexttoSPeech made in VB. VB can open files as binaries and the convert it to unicode to displayed in an editbox which can show characters of any language The code is this: Open ComDlg.FileName For Binary Access Read As 1 MainTxtBox.Text = StrConv(InputB$(LOF(1), 1), vbUnicode) Close #1 I could find equivalents for VFP. STRCONV function offer some of this but the equivalent function in VB is different. I could not display chinese words in an edit box. Had someone done something similar? Thanks. Alejandro Fernandez Tag: How to get the dbc name for an open table Tag: 236451
  - 24
    - Open Word file in Vista I have another problem with an application that runs OK in XP, 98, and 95 but not Vista. I open a Word.doc file from a command button in a form as below in XP, 98, or 95 and the Word doc file opens and displays on the screen so the user can enter a letter in Word. When I use the same file in Vista it pops up on the task bar and the user has to click on the task bar to open the file up. oWORD = GetObject(MYLOCATION+'\'+'C_FILE_NUM+'.DOC') WITH oWORD .APPLICATION.WindowState = 1 .APPLICATION.VISIBLE = .T. ENDWITH No problem staring up Word with the document but it always ends up on the task bar when run in Vista. Is there something to add so it will open up without the user having to click the taskbar?? Tony Tag: How to get the dbc name for an open table Tag: 236446
  - 25
    - RUN xcopy COMMAND IN VISTA I have been using the RUN xcopy in an application using variables with no problem until I installed it in a Vista Operating system. from = "C:\PFILES\*.*" to = "C:\BACKUP" RUN XCOPY &FROM &TO &&This works OK in XP or 98 but not in VISTA This will run in VISTA RUN XCOPY "C:\PFILES\*.*" "C:\BACKUP" If I try and use the variables like in XP it will not run. There is no error but the command window comes up and then shuts down. I need the variables as they are field inputs that the user enters. Any suggestion would be appreciated. TonySper Tag: How to get the dbc name for an open table Tag: 236429
- Next
  - 1
    - RUN Question I still have yet to learn about ShellExecute and would like to continue to use the RUN command because of the ability to leverage the "File Association" aspects of windows. In the CMD.COM and COMMAND.COM environment using the windows start menu "run" command, from the command prompt; START <filename.ext> ...will launch the users application of choice for that file extension, but VFP's "RUN" command launches NTVDM.EXE which seems to be a pretty crippled command shell... START for one won't work. I can address this by replacing the FOXRUN pif with a copy of the windows DOS pif, but would like some wisdom on what NTVDM.EXE is and how others deal with it. Thanks in advance, Beverly Howard Tag: How to get the dbc name for an open table Tag: 236426
  - 2
    - VFP9: Trouble updating view Hello, I have two views, both utilizing the same table. The views are simple and based on a single common table. The only difference between the two views are the filter parameters. All the proper PK and update fields have been checked in the view builder. Both these views reside in the same form data environment. Both views use default table buffering. The trouble starts when I save changes to an exsisting record, it requires that I save the changes twice before the base table recieves the update. I'm stumped! John Tag: How to get the dbc name for an open table Tag: 236423
  - 3
    - Spinner Events (Still vfp7) First time using a spinner control and not understanding when the spinner sourcecontrol is updating... In this example, the spinner controlsource is a form property containing a numeric value. The resulting value is used in a SEEK which, if successful, updates the form. Question: When is the spinner controlsource updated? I'm finding that I have to run math on the value to execute the seek... for example; If it's a "DownClick" event, I have to subtract the increment from the controlsource to execute the seek for the expected value following a downclick. What concerns me more is that when trying to track this using the debugger, the value did, at some points, decrement during the processing of the downclick event. Thanks in advance, Beverly Howard Tag: How to get the dbc name for an open table Tag: 236422
  - 4
    - Drag and drop onto report builder I give my users the chance to modify reports within our application. They also have various data entry forms. It is possible to have both open at the same time. The ideal way for a user to add a new field to the report would be to go to the data form and DRAG the field from the form onto the report builder surface. That way the user doesn't have to think about the internal field name and all that stuff. Ideally, as it was being dropped, it would call some method or procedure in which I could examine the field (object) being dropped and return .T. or .F. to permit it. Also maybe to extract the field name from object dropped, and do other stuff. Any ideas how this might be done? Tag: How to get the dbc name for an open table Tag: 236420
  - 5
    - Network Messages I'm writing a program that monitors a network directory for incoming ftp files. Is there a way to send messages to the users who need these file when they arrive? Hopefully, I can do this without installing the monitoring app itself on all their desktops. -- -Lew The workers took the robot for Maria. Tag: How to get the dbc name for an open table Tag: 236410
  - 6
    - Get Paper Name & Orientation from Crystal Report Hi, i am using visual foxpro 9 ith crystal report 11 R2. to open report i use ; crxreport = crxapplication.openreport("test.rpt") now how i get the paper name, paper size, orientation & report file name from foxpro. thanks Tag: How to get the dbc name for an open table Tag: 236408
  - 7
    - Modify Report - failure and error message A report is stored on the server. Various users on the network want to modify the report from time to time, and run it. They Modify Report from their Command Window and are in the Design view. Then they can switch to the Preview view. Here is where the error comes in. Some users can then switch back to the Design view to keep tweaking the report, and switch back to Preview. That is, they can switch back and forth between Design and Preview. Other users can switch from the initial Design, and then to Preview, but when they try to switch back to Design, the process crashes with an error which reads: ! Cancel. OK Help The exclamation mark is in a yellow triangle, and the whole thing is in a rectangle. This is a strange message which says nothing. Now this is really an insignificant error, because the users can go right back from the Command Window into Modify Report. Still, it's bothersome, and it makes one wonder what's going on? By the way, all users have a full copy of VFP 6.0 installed on their local machines. Tag: How to get the dbc name for an open table Tag: 236371
  - 8
    - ODBC: Is this a bug? vfp 9, SP1 The point of the following was to determine if an ODBC connection is available on the current machine and it works fine for that purpose. However the added ? statements show what seems to me to be a bug. ? DBUSED('lms_logger') && returns .F. TRY USE (odbc_path+'lms_logger!header_view') IN 0 ALIAS test rtn=.T. CATCH rtn=.F. ENDTRY IF rtn USE IN 'test' ENDIF ? DBUSED('lms_logger') && returns .T. * * However, if you try to create an SQL view at this point, it throws an error * that no database is open * CLOSE DATABASE ? DBUSED('lms_logger') && still returns .T. OPEN DATABASE (odbc_path+'lms_logger) CLOSE DATABASE ? DBUSED('lms_logger') && is now F There is probably a better way for me to test the connection. And, this is easy enough to work around. Still, it seems to be odd behavior. G Tag: How to get the dbc name for an open table Tag: 236363
  - 9
    - Report Preview When you send a report for preview is there a way of eliminating the command box that appears in the upper left corner that allows the closing or printing of the report?? The reason is that I first let the user preview the report and then after they close the preview I bring up a message box that asks if they want to print the report. It appears that some users print the report to close it and then print the report again. Some user get confused easy. Thanks for any suggestions. TonySper Tag: How to get the dbc name for an open table Tag: 236362
  - 10
    - Grid not following A while back posted and discussed a VFP7 problem concerning a form where the grid and current record pointer was not being maintained following actions such as an index change but never really addressed it because of the need to meet other needs. Tinkered with it today and found that even though the thisform.refresh does nothing related to record position, the solution turned out to put the "goto <recordnumber>" _after_ the form refresh. hope this helps, Beverly Howard Tag: How to get the dbc name for an open table Tag: 236358
  - 11
    - ActiveX and Socket Programming Has anyone used sockets with VFP? In particular, I have the mabry socket control and I'm trying to understand how to send and receive files. I know how to open the socket and use the methods and events to instant message and send a small packet of data over the LAN or the internet but I don't understand how to send a large file. I can't use FTP because I want to send the data directly to an IP address on a LAN via the internet in my application. It seems that the size of the buffer is around 8K by default but I'm confused as to whether the host tells the client "I'm ready for the next packet" or does the client just send the data to the host. Is there some standard protocol for this and also how does the host know when all the data is received since when opening a socket one can continue endlessly sending data? Thanks, Mike Tag: How to get the dbc name for an open table Tag: 236324
  - 12
    - Total to <Fieldname>... is <FieldExpr> ok? I'm looking at some old code that uses the total to command. The help file specifies that the syntax is total to <TableName> on <FieldName> (ie group on a single field value), but the code I see uses a field expression, ie <Field1+Field2+Fieldx+etc>. It seems to work ok. Can anyone confirm that this will always be the case or are there gotcha's.... like what happens when the FIeldExpression reaches a certain length or the actual field widths exceed a certain total. -Lew Tag: How to get the dbc name for an open table Tag: 236322
  - 13
    - replace syntax I am issuing the below syntax, and the result is it not only changes what it is supposed to, but also records where groupid = 54 REPLACE ALL groupname WITH "Customer Cell Numbers" FOR groupid = '5' Tag: How to get the dbc name for an open table Tag: 236314
  - 14
    - Slow Accessing a memo field on a network Anyone have any ideas about this: here's the situation, I have a memo field that I use in a table and I read various lines from the memo field for default settings. This makes it so that I don't always have to modify the structure of the table. The total length of the memofield is small (under 3K). However, I have to read the memo field multiple times to get the default values on any particular line. For example: set memowidth to 8192 test1 = mline(mytable.mysettings, 1) test2 = memline(mytable.mysettings, 2) test3 = memline(mytable.mysettings, 3) test4 = memline(mytable.mysettings, 4) There are about 150 lines at present in the field. Here's the strange thing. I have a method in a form that reads all the values and sets the objects on the form accordingly. It seems like it is starting to take a long time to load the form (around 6-10 seconds). But, this delay is ONLY PRESENT if the table is open on another computer on the network. If I open the table on the same computer in a separate program (such as VFP) or I run another instance of my application, then everything is fast. The slowness only happens if the table is open on another workstation and it appears that it is just as slow if the table is open on 2 workstations or 10 (makes no difference). It drastically speeds up when the table is open on only one workstation and is fast even if that table is open on one computer with multiple programs (such as if it is open in my app as well as open in VFP). I have noticed this problem on both an XP Pro computer (as the server) with XP workstations and I have also noticed this problem on a real Win 2000 server with XP workstations. I'm using VFP 6/SP3. The problem only seems to happen when doing multiple reads from the same memofield many times. In other words, if I do this instead: m.lcMain = mytable.mysettings and I then populate the form using m.lcMain then everything is very fast. It's as if multiple reads to the same memofield is really slow but only if the table is open on another workstation. There are no virus checkers or other programs (that I know of) to slow it down). I can't understand why this is happening but I'm not sure if it is happening on other server OS's as well or just these few examples I have provided. I'm running the exe on the local machine. But, it seems to be some kind of network issue because the speed drastically slows down (reading the memo field multiple times) whether the table is open on two workstations or 10. It's then pretty much the same slow speed when open at 2 computers or more but lightening fast when open at only one. Anyone have any ideas? Thanks, Mike Tag: How to get the dbc name for an open table Tag: 236303
  - 15
    - Trigger How can I write a very simple piece of code in a delete trigger so that no orphans arise? The referential integrity builder is too complex, and crashes my VFP9 SP2. Walter Tag: How to get the dbc name for an open table Tag: 236300
  - 16
    - Validating data, tricky one... Hi: I need to validate that records have been entered correctly in a table, by correctly I mean in ascending order. But with a small variation, the first record can have any value, so: Field1 100 2 3 4 5 6 This is correct, because record 1 can have any value, but : Field1 88 2 3 7 5 6 Is wrong, can I validate this using VFP? Tag: How to get the dbc name for an open table Tag: 236289
  - 17
    - Validating data, tricky one... Hi: I need to validate that records have been entered correctly in a table, by correctly I mean in ascending order. But with a small variation, the first record can have any value, so: Field1 100 2 3 4 5 6 This is correct, because record 1 can have any value, but : Field1 88 2 3 7 5 6 Is wrong, can I validate this using VFP? Tag: How to get the dbc name for an open table Tag: 236288
  - 18
    - .net + fox com objects We have a program written in VB.net using the version 2 framework. The program uses a fox com object written using vfp8 and compiled as an exe. On our development machine everything works fine, it also works on SBS 2003 in our office. The problem is when we deploy it on our customer's SBS2003 machine we get the following error. The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) at satnavcom.htsatnavClass.set_CEXEPATH(Object CEXEPATH) at satnav.Form1.startdata() at satnav.Form1.DoWork() The error occurs at the point where a property of the com object is set. If I comment out the code which sets this property we get the same error but on the line which sets the next property. CEXEPATH in the exception above is the com object property it fails on. All necessary runtimes are on the machine and it is registered correctly. I have spent hours on this problem without success, has anyone come across any similar problems. I have tried giving everyone permission to this com object use dcomcnfg but it still doesn't work. TIA Dave Tag: How to get the dbc name for an open table Tag: 236279
  - 19
    - Locate vs Seek Command Hi: I have a small aplication that runs only with free tables. I have been hearing that CDX files could get corrupted for a number of reasons, but the only reason I need the indexes is for some seek commands to validate certain fields. My tables are actually small mostly on the range of 500 to 1000 cases. Is is a good idea to change the seek commands with locate commands in order to avoid generating indexes, are CDX files necessary on free tables. should I expect performance problems with this change? Thanks for your time!!! Tag: How to get the dbc name for an open table Tag: 236278
  - 20
    - Help: SQL remote view compare to local table Hello, having trouble with a solution to only query new records in a remote view and would like some help. Have a local table (free vfp table) with an ID field and a remote view to SQL table with the same ID field. What I want to do is change the remote view query to the SQL table to pull only records where the ID's do not match the local table. The reason is that this particular table contains 500,000 records and I'm trying to reduce the amount of data being pulled in the remote view itself. The result set would then contain only new records in the remote view since my last pull. No consideration needs to be made for changed records, just new records in the remote view as determined by an ID that does not match the local free table. I'm was thinking something like, use the remote view, use the table then a compare loop but that defeats the purpose as I'm still pulling all records in the remote view. Using the CREAT SQL VIEW and within the AS SELECT portion, can I reference data from the remote connection AND a local table at the same time? But if the local table isn't part of the remote connection won't that mess up? So the SELECT would be something like CREATE SQL VIEW 'MyView' REMOTE CONNECTION 'MyConn' AS SELECT RemoteViewTable.Field from RemoteViewTable where RemoteViewTable.Field = LocalFreeTable.Field? I suspect my approach is off....any ideas? TYIA =Ben Tag: How to get the dbc name for an open table Tag: 236273
  - 21
    - VFP 9: INSERT-SQL into a Table from the Same Table YA variation of "How do I do this with only ONE SQL statement?": The client billing app that I maintain has Work Function Codes (WFC) for the types of work that are performed. These have an expiry date (validtil). My boss now wants a program for automatically generating the next ones. I have a cut for the basic code. It takes three SQL statements. Is it possible to do it in one? goyear() is like gomonth() except that it works by years and it makes sure that YY-02-28 becomes (YY+offset)-02-29 when YY-02-28 is at the end of the month. WFCs are uniquely specified by funccode-clcode-wccode-validtil. The first cursor contains the WFCs that will be used to generate the new year's WFCs. This code allows for a WFC to lapse so that no longer used WFCs do not keep getting generated each year. (latestdt is the last day of the yearlong period for which the new validtil value can be. If it would not be in this range, then a new WFC is not to be generated.) ***** Start of Included Code ***** latestdt={^2008.12.31} select * from cwkf as out; where; clcode="BHU" and validtil=; (; select max(validtil) from cwkf; where; funccode=out.funccode and clcode=out.clcode and wccode=out.wccode; ); and goyear(validtil,1)>goyear(latestdt,-1) and; goyear(validtil,1)<=latestdt; into cursor togen readwrite update togen set validtil=goyear(validtil,1) insert into cwkf; select * from togen ***** End of Included Code ***** I could change the insert to specify each individual column and save having the update statement, but that is more trouble than it is worth. (Suppose I add a column to cwkf. Then, I would have to update this program, too.) What I am hoping for is a way to insert in one statement. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: How to get the dbc name for an open table Tag: 236264
  - 22
    - Triggering an application from SQL Server? Hi, I was just wondering would it be possible to have a trigger in a SQL 2000 database launch a VFP application to print a label? I think setting up the trigger is pretty straight forward but having it launch a VFP application is more tricky. I guess the trigger would have to pass a couple parameters that the application would use for a look up. Is this possible and what would I have to do on the VFP end to make it work? Thanks in advance, Linn Tag: How to get the dbc name for an open table Tag: 236256
  - 23
    - combobox readonly? Just got bit by the fact that vfp7 didn't object to a combobox object being set to readonly within a method. ...turns out that doing so is ineffective and that the combobox will still change the control source in that state <sigh> So, on the surface, it seems as if the only direct option is to set the combobox to .not. enabled. However, that also precludes being able to view the combo box's contents, so, wondering if there is an easy way to allow the user to view the pulldown while preventing it from changing the control source? Thanks in advance. Beverly Howard Tag: How to get the dbc name for an open table Tag: 236251
  - 24
    - SQL help needed Hi, I'm having a hard time figuring out the best way to write an SQL query to do the following. I want to search a whole table (every field) for a word like "software" and filter it by multiple clients and vendors that the user has chosen. This is my SQL so far, but it doesn't work SELECT Etlpws.unqentry, Etlpws.category, Etlpws.client, Etlpws.vendor,; Etlpws.desc, Etlpws.wsaddy, Etlpws.wsfolder, Etlpws.wstaticip,; Etlpws.swprodname, Etlpws.swprodkey, Etlpws.swpurdate, Etlpws.swcategory,; Etlpws.swtype, Etlpws.swusers; FROM ; etlpws; WHERE ( ( ( Etlpws.category = ( "software key" ); AND Etlpws.client = ( "External Client" ) ); AND Etlpws.client = ( "My Company" ) ); AND Etlpws.vendor = ( "Microsoft" ) ); AND Etlpws.vendor = ( "IBM" ); AND Etlpws.desc LIKE "%software%"; ORDER BY Etlpws.client, Etlpws.fullname; INTO CURSOR Sw_query So I have 2 problems. 1. I can't figure out a way of telling the above SQL to search every field for my search term. I'm currently only testing using one field which is the 'desc' field. But need this to search all the fields. 2. The multiple where statements "AND Etlpws.client" end up displaying every record that matches the client name which is correct, but it's including records that don't have a matching "software" result found in the "DESC" field. So instead of getting 2 results, I end up with 58 records with the wrong data in it. I've tried changing it to say OR instead of AND but then this displays 0 results. Can anyone point me in the right direction? Thanks Tristan Tag: How to get the dbc name for an open table Tag: 236250
  - 25
    - Distributing my application? Hi, Ok, I'm now trying to distribute my application and I built the installer with install shield express. My original attempt worked fine, program installed and it ran. Then my users asked for a new feature, no problem I said and went to work. Added the feature, rebuilt the application and the installer. The only thing unusual that I did with the application was to add the datetime picker control. Now after installing my app. it doesn't work. It launches, I can see it listed in the task manager but nothing displays. No error messages, nothing in the event viewer. I'm not sure what to even look at. Any suggestions? Here is a list of the redistributables I have added to the installer: GDI Plus Redist module Microsoft C Runtime Library 7.1 Microsoft Component Category Manager Library Microsoft OLE 2.40 for Windows NT and Windows 95 Microsoft Visual FoxPro 9 Runtime Libraries Microsoft Windows Common Controls-2 (6.0) Is there something I'm missing from this list? What else should I be looking at? Thanks in advance, Linn Tag: How to get the dbc name for an open table Tag: 236248

Given an environment in which there are multiple open dbc's and open tables.
Is there a simple way to get from an alias back to the name of the dbc the
underlying table belongs to without iterating through adatabases() and
adbobjects()?
-Lew

Top

Re: How to get the dbc name for an open table by Michel

Michel
Tue Oct 02 13:05:07 PDT 2007

cursorgetprop("database", your_alias_to_test)

--
Michel Lévy
Communauté Francophone des Professionnels FoxPro
Pour un développement durable...
http://www.atoutfox.org
--
"Lew" <Lew@discussions.microsoft.com> a écrit dans le message de news:
BC1081CF-2789-48EC-B10C-C6C72E7784DA@microsoft.com...
> Given an environment in which there are multiple open dbc's and open
> tables.
> Is there a simple way to get from an alias back to the name of the dbc the
> underlying table belongs to without iterating through adatabases() and
> adbobjects()?
> -Lew

Top