Network Workstation Q.

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
    - delete directory Group, How can you delete a directory in code if it has files in it? (vfp6) Wade Tag: Network Workstation Q. Tag: 241613
  - 2
    - duplicate records Hi .. i am trying to update a table in foxpro 6.0 where if field contents any duplictaed entries than one of the field should be updated with random number which is unique so i can make all entries unique i searched a lot but couldn't find any solution which i could understand easily . is it very difficult in sql to update duplicate entries with new unique random values? table example : id is primary key ---------------------- id | name | age ---------------------- 1 a 24 2 b 24 3 c 28 4 d 12 5 e 12 in the above table id is unique but the age is same for a , b and d,e . what i am trying to do is that in a single query i can update table set age=age+random unique number where duplicate age exists . that mean b will become 24+some random number and e will be 12+some random number hope someone reply's soon thanks Tag: Network Workstation Q. Tag: 241611
  - 3
    - Other Discussion Groups, Newsgroups other than MSDN No offense here, but MSDN Newsgroup here for Microsoft Visual FoxPro is a little weak...and understandable now that Microsoft has pulled the plug on it. Does anyone know of any other Microsoft Visual FoxPro Discussion Groups, Newsgroups out on the Internet other than MSDN??? Thanks in advance for your help. PSULionRP Tag: Network Workstation Q. Tag: 241600
  - 4
    - SQL Server and Microsoft Visual FoxPro I am really struggling with the Microsoft Visual FoxPro syntax to SQL Server. I actually have to CREATE a SQL Server Table. I seem to be doing that ok. It's the INSERT to this table from Microsoft Visual FoxPro that I am struggling with. Does anyone know of some good training sites for SQL Server interface with Microsoft Visual FoxPro or some where I can find syntax??? I have scoured Google and can't seem to find anything. Thanks in advance for your help. PSULionRP Tag: Network Workstation Q. Tag: 241599
  - 5
    - Trapping events in BROWSE window I come from FPW 2.6 moving to VFP9 and I have enhanced my BROWSE command adding NAME so that I can set colours for headers, columns, rows, gridlines, etc. Is it possible to trap under this schema for events like double clicking a column, clicking on a column header, etc. ? Please remember that I don't use forms. Walter Tag: Network Workstation Q. Tag: 241597
  - 6
    - Declare DLL String limit This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C8E42B.8897B730 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using the declare dll command in VFP 6.0 and 9.0. The DLL decides = if there are errors and if so outputs an errors.txt file. The code is = below. If I do it in 6.0 it works fine. In 9.0 the errors.txt file = gets truncated at about 4k. Is there a way around this. DECLARE INTEGER MYDLL IN MYDLL; STRING @, ; STRING @, ; INTEGER @ InFile =3D "InData.txt"=20 OutFile =3D 'ERRORS.TXT' ErrCount =3D 0 ErrLevel =3D MYDLL(InFile, OutFile, ErrCount) if ERRLEVEL =3D 4 WAIT WINDOW 'Warnings in output. See ERRORS.TXT file for details.' !NOTEPAD 'ERRORS.TXT' ENDIF TIA. BR ------=_NextPart_000_0008_01C8E42B.8897B730 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3354" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff background=3D""><FONT face=3DArial = size=3D2></FONT> <DIV><FONT face=3DArial size=3D2>I am using the declare dll command in = VFP 6.0 and=20 9.0.  The DLL decides if there are errors and if so outputs an = errors.txt=20 file.  The code is below.  If I do it in 6.0 it works = fine.  In=20 9.0 the errors.txt file gets truncated at about 4k.  Is there a way = around=20 this.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>DECLARE INTEGER MYDLL IN=20 MYDLL;<BR>          &nb= sp;           &nbs= p;           &nbsp= ;=20 STRING @,=20 ;<BR>           &n= bsp;           &nb= sp;           =20 STRING @,=20 ;<BR>           &n= bsp;           &nb= sp;         =20   INTEGER @<BR></DIV></FONT><FONT face=3DArial size=3D2></FONT> <DIV><FONT face=3DArial size=3D2>InFile =3D "InData.txt" <BR>OutFile =3D = 'ERRORS.TXT'</FONT></DIV> <DIV><FONT face=3DArial size=3D2>ErrCount =3D 0<BR>ErrLevel =3D = MYDLL(InFile, OutFile,=20 ErrCount)<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2>if ERRLEVEL =3D 4<BR> WAIT WINDOW = 'Warnings in=20 output. See ERRORS.TXT file for details.'<BR> !NOTEPAD=20 'ERRORS.TXT'</FONT></DIV> <DIV><FONT face=3DArial size=3D2>ENDIF</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV> <DIV><FONT face=3DArial size=3D2>TIA.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>BR</FONT></DIV></DIV></BODY></HTML> ------=_NextPart_000_0008_01C8E42B.8897B730-- Tag: Network Workstation Q. Tag: 241595
  - 7
    - Using a SQL Cursor to INSERT into another Table I have a SQL SELECT into a Cursor. Can I use the cursor results as a host variable and INSERT this data into another table??? SELECT column1, column2, column3 FROM Table1 SQLEXEC(dataconn,lcSQL,"cursor") SELECT cursor GO TOP DO WHILE NOT EOF() lcinsertsql = [ INSERT INTO Table2 ] +; [ (columna, ] +; [ columnb, ] +; [ columnc ] +; [ VALUES ] +; [ (ALLTRIM(STR(cursor.column1)), ] +; [ ALLTRIM(STR(cursor.column2)), ] +; [ ALLTRIM(STR(cursor.column3))) ] Does this look right??? Any suggestions??? Thanks in advance for your review and help. PSULionRP Tag: Network Workstation Q. Tag: 241583
  - 8
    - Confuse behaviour calling a DLL I´m using a DLL with several readonly tables inside. Sometimes trying to open one of these tables I got the error "File MyDBF does not exist". On displaying memory and status to files I couldn´t find changes at all. No database is open. These are free tables. What other environment changes can I compare? Thanks. Alejandro Fernandez Tag: Network Workstation Q. Tag: 241577
  - 9
    - excel automation datatype I'm pushing a table into an excel work sheet by iterating through the table, doing a scatter .... <to array> and .Cell[row,col].Value = array[col] etc... Using this method, however, vfp date types seem to be converted to characters like "mm/dd/yy" instead of an excel date type (if there is one). How do I make sure excel winds up with one of its internal date types? Tag: Network Workstation Q. Tag: 241567
  - 10
    - Declaring Variables How come sometimes I see LOCAL variables being explicitly defined and then other times I don't...they seem like they're being defined on the fly. Is this bad coding discipline??? Arrrrrrgggggggghhhhhhhhh PSULionRP Tag: Network Workstation Q. Tag: 241563
  - 11
    - vfp 9 printer setup overrides printer driver i am trying to print lables. in doing this, i need to print them portrait 180. i set this up in the printer driver this way, but in foxpro it shows and prints portrait. is there a patch for this? thannks, Marty Tag: Network Workstation Q. Tag: 241559
  - 12
    - Confusing performance difference VFP8 SP1 on XP Pro SP2 I have some code that was running a bit slowly: SELECT DISTINCT colToFix ; INTO ARRAY colArray ; FROM myTbl SELECT myTbl FOR EACH curVal IN colArray lcNewVal = ThisForm.Standardize(curVal) REPLACE colToFix WITH lcNewVal FOR colToFix = curVal ENDFOR There is an index on the ColToFix column. myTbl is a free table. Standardize is a method that makes sure the passed in value follows certain formatting rules. On a table with 50K records, this was taking almost 2 minutes. There are about 10 distinct values in the column in question. All of the execution time was happening in the 10 calls to REPLACE - some of them taking over 20 seconds! With such a small table and indexed on the column in question, I would think each REPLACE would take no more than a second. I've tested on many, many tables of the same size with the same result, so it's not a corruption issue. Playing around with it, I changed it to the following: SELECT myTbl SCAN REPLACE colToFix WITH ThisForm.Standardize(colToFix) ENDSCAN Amazingly, this was 5 times faster! How could performing 50K replacements and 50K calls to the standardize method take *less* time than doing 10 calls to each?!? This was also 5 times faster: SELECT myTbl REPLACE colToFix WITH ThisForm.Standardize(colToFix) ALL I rarely have performance problems in VFP, so this one's a bit of a head scratcher. Any ideas on why this difference and how to possibly make this run even faster? -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: Network Workstation Q. Tag: 241557
  - 13
    - VFP column type using SQL I have a situation where I am doing a SQL query within a FoxPro .prg. The program is assuming the data attributes from SQL and I'm specifically going after an INT column type. And I have to pass back a <blank> in this field rather than the value. If I set up a global or local variable, can I move the SQL result column to this global/local character field and then pass the <blank> that way??? I also thought about doing a CAST or CONVERT in my SQL statement, but I'm not sure how to pass back a <blank> that way either. The problem here is that is one big UNION Select and I only want to do this in the one UNION condition. I am sort of new to Visual FoxPro. How does FoxPro discern whether a working storage global or local variable is character or numeric??? Can anyone help me out here??? Thanks in advance. PSULionRP Tag: Network Workstation Q. Tag: 241549
  - 14
    - Error only reports "click" I have an application with an error handler that saves information on errors. For some errors, though, instead of reporting the form and/or function that caused the error, Exception.Procedure only returns "click". This makes it very difficult to track the error. Am I doing something wrong? Is there any way to track the procedure that causes this error? Is there a known situation for which Exception.Procedure returns only "click"? Regards, Kevin Clark Seton Home Study School Tag: Network Workstation Q. Tag: 241547
  - 15
    - VFP 9.0 report template returns printer to default I have a third party application that uses vfp9.0. When i try to save a printer to the report template, it goes back to the default printer. i am unable to save the non default printer. we use this application to print labels using a datamax printer. we need to be able to save the datamax printer because it uses labels different then 81/2 X11. in trying to resolve this, i contacted teh third party, and they responded that this was a vfp 9.0 bug and not their bug. they had a vfp application that was supposed to solve this, but it didn't. i went to vfp 9 and created a sample report. i then tried to save a non default printer, and it did the same thing. after closing and opening the report, the default printer was selected again. is there any patches to fix this? any help would be appreciated. thanks Tag: Network Workstation Q. Tag: 241538
  - 16
    - Little black box in .dbf Please excuse my newness to Microsoft Visual FoxPro. There is a little column in a database file and it is sometimes black and sometimes not. Is this like an active flag or something for data rows?? Black meaning it is not active??? Thanks in advance. PSULionRP Tag: Network Workstation Q. Tag: 241531
  - 17
    - FPW 2.6 and SHOW WINDOW oddness Hello group, hope all are well.. I stumbled across an unusual behaviour this morning, trying to refresh a browse window called "Reorder" closes the window. Does anyone know why? I don't think "REORDER" is a keyword, have I stumbled across something magic? Incidentally, is there somewhere (in the help maybe?) I can see a list of keywords for FPW2.6? *--------------------------------------- code... * type a new value in the field and press enter - * this causes a SHOW WINDOW ... REFRESH to be executed * and it has the magic effect of closing the window * the problem is apparently calling the window 'Reorder' * issuing SHOW WINDOW ALL REFRESH will refresh it correctly * but any way of referencing the single window (eg 'Reorder' * or WONTOP etc.) seems to cause this behaviour CREATE CURSOR test (test C(30)) INSERT INTO test (test) VALUES ('change me and press enter') BROWSE TITLE 'Reorder' ; FIELDS test :v=refwind() ****************** FUNCTION refwind ****************** * refresh browse window SHOW WINDOW (WONTOP()) REFRESH *--------------------------------------- end code.. -- best regards Andrew Howell Tag: Network Workstation Q. Tag: 241525
  - 18
    - Using default font under Vista (or XP) Out of curiousity, does anyone know how to get Foxpro to use the standard Windows font for form labels, textboxes etc without having to manually set the font as such? ie. If the app is running under XP, then form objects will display using Tahoma (for example) or if running under Vista then Segoe UI. If that is not possible.... Setting the font to default for a form object seems to set it to Arial. Is there some way of changing this default font setting for VFP such that all forms pick this up? Alas, many of our forms don't use label/textbox classes so doing it in a class is not an option. Thanks, Andrew Tag: Network Workstation Q. Tag: 241520
  - 19
    - tooltips in grid headers not showing I cannot get the tooltips in grid headers to show up. Is this a bug or am I doing something wrong. (VFP9SP2) If I cannot fit enough text in the header I would like to use the tooltips to show additional information. Max Tag: Network Workstation Q. Tag: 241515
  - 20
    - Is an .exe running - revisited I asked a question earlier where I would like to check if an external app (non-foxpro) is running as was given the code below to place in a function. It works great and detects if an app is running however, when I close the other app, and do a test to see if it still running, calling the funton still indicates the other windows app is still runing but it's not. I tried issuing clear dlls but it doesn't help. If I leave FoxPro and come back in, it resets the function and it now works but once the other app is run, it again indicates the the other app is running after I close it. Is there anyway I could fix this issue. It seems to only work until the first instance of the external app is run. TIA Mike. PARAMETERS pMutex && pMutex=Program name #DEFINE ERROR_ALREADY_EXISTS 183 DECLARE INTEGER CreateMutex IN WIN32API INTEGER, INTEGER, STRING @ DECLARE INTEGER CloseHandle IN WIN32API INTEGER DECLARE INTEGER GetLastError IN WIN32API nExeHwnd=CreateMutex(0, 1, @pMutex) IF GetLastError()=ERROR_ALREADY_EXISTS CloseHandle(nExeHwnd) =MESSAGEBOX(pmutex+" Is Already Running",64,registname) RETURN .F. ELSE RETURN .T. ENDIF Tag: Network Workstation Q. Tag: 241512
  - 21
    - Shortcut or Popup menus on top level forms VFP8 SP1 on XP Pro SP2 I have a form with ShowWindow=2 (As top level form). I am using the MenuLib class in the Utility.vcx library to dynamically create and show a popup menu when a certain control is Right-clicked on. This worked fine when ShowWindow was set to 0 (in screen), but with the form as a top level form, the popup no longer appears. I suspect it is being displayed *behind* the top level form or in the SCREEN (??!). This makes the popup unusable, needless to say. The MenuLib class uses DEFINE POPUP to build the popup menu then SHOW POPUP to display it. I don't see anything in the help file about this not working on a top level form, but there is obviously something amiss here. Any idea how to make this work? -- TRW _______________________________________ t i m . w i t o r t _______________________________________ Tag: Network Workstation Q. Tag: 241511
  - 22
    - FoxPro Automation Q. I have started passing data back and forth from Foxpro and Outlook's Contacts. The only problem is that I do not know all the names of the fields in Outlook's Contact section. ie. the attached picture file, the notes field... Where can you get a listing of all the objects in outlook? Has anyone ever plowed this ground already and willing to share some code? Your knowledge is greatly appreciated. Jonathan Morningstar Edisto Island, South Carolina, USA Tag: Network Workstation Q. Tag: 241509
  - 23
    - Active Source Control Provider not recognizing VSS is installed Hi, My machine crashed, so I'm setting up a new machine with my dev environment. I've never had a problem with VFP finding my VSS installation before, but I do now. I have VSS installed, I can see it in the registry, it's hooked up the project and I can use the VSS environment just fine. But when I go to VFP's Options for the project, and drop down the Active Source Control Provider box, it's empty. I checked and I am running VSS from a local installation, not off a server. How do I tell VFP where to find VSS? I assumed it would find it in the registry. Thanks Cathy Tag: Network Workstation Q. Tag: 241502
  - 24
    - SQL - lates date entry I have a table for different engine parts were the date of the last overhaul of a particular part is entered Something like: 1. engine1; unit1; some details...; date1 2. engine1; unit1; some details...; date2 3. engine1; unit1; some details...; date3 4. engine12; unit7; some details...; date1 5. engine12; unit7; some details...; date2 6. engine12; unit7; some details...; date3 ect... On a form an engine and a unit can be selected and in a grid with a view the history of the maintained parts will be visible. My problem is, I cannot figure out how to get only the last date entry of each engine and unit, in above sample it would be line 3 and 6 only. Any help would be appreciated Thanks Max Tag: Network Workstation Q. Tag: 241495
  - 25
    - Tables become corrupted in Terminal Server Session My scenario: application's exe (vfp9) running from a file server, on 30 computers and there are also 10 sessions of terminal server who run on another server (not the file server). The users of the 10 sessions are 3 miles away from both file server and the terminal server. Connection is over a 2 MB point to point line, with a good ping of about 30 ms. Surprisingly, from time to time some tables on the file server become corrupted, and I can see that these tables had been in use by the "remote" people in terminal server mode. (These are the only people that can update the corrupted tables. The "local" people just open the tables with NOUPDATE). For example today, one of the tables that became corrupted, indicated with Foxfix5 a wrong record count. The table is small, about 15000 records, with a record length of 50, that means 750 kB. Is there a chance to get a corrupted table because of a micro cut in the connection to the remote office? I could understand this if it were a true client-server application, but it runs on a LAN and on terminal server, this means only video is updated. What else can be happening ? Walter Tag: Network Workstation Q. Tag: 241494
- Next
  - 1
    - animated gif Hi I have a form(form A)(vfp8) the only thing on this form is an animated gif. In the activate event I call another form(formB) at that point the gif is no longer active. How can I keep the gif moving while the other form is loading? Also..what code and where do I put it to close form A.(it stays running under form B.(it is also moving again.) Thanks Sherry Tag: Network Workstation Q. Tag: 241492
  - 2
    - Outlook Contacts Automation Q. Greetings, How can you create an additional address book inside the Outlook contacts folder via VFP code? I know how to add contacts from VFP into Outlook but I need them to go into a new folder in the Outlook contacts. Respectfully, Jonathan Morningstar Greenville, South Carolina USA Tag: Network Workstation Q. Tag: 241484
  - 3
    - limitation on string of 255 bytes??? hi i can't create a string of more than 255 bytes.... what is happening...? this don't occurred before... bye, thanks ks Tag: Network Workstation Q. Tag: 241480
  - 4
    - Project hook There are a couple of prgs that I have to remember to run before creating the exe - e.g. initialising some tables that are stored R/O within the exe. I have never done anything with project hooks before, but believe that this is the way I should do this. Can somebody point me to a helpful article or explain simply how I set this up? Many thanks Stephen Tag: Network Workstation Q. Tag: 241471
  - 5
    - Problems running code created by GENDBC When the app begins the function MakeRI to write store procedures, the statement CLOSE DATABASE USE "MYDBC.DBC" I got the error "File is in use" Does knows somebody this behaviour? Thanks. Alejandro Fernandez Tag: Network Workstation Q. Tag: 241468
  - 6
    - What about Sybase iAnywhere's Advantage Database Server ? I am trying to attend South West Fox conference in Arizona in October, and one of the sponsors is Sybase. Does anybody have got an experience with their Advantage Database Server? Does it replace SQL Server? Pros? Cons? Walter Tag: Network Workstation Q. Tag: 241464
  - 7
    - Software Development Services, Software Outsourcing Services In India Software Development services in India suggest IT Solutions for Software outsourcing services, Software Design, affordable software technology and Programming Development by frequent Software Testing. More information for visit our site http://www.itoutsourcingservices.com/software_development.htm Tag: Network Workstation Q. Tag: 241452
  - 8
    - Quit To ... There used to be a DOS-days (Foxbase?) command QUIT TO <Some other app> where <Some other app> would start automatically after exiting Fox. I could probably replicate this by creating a batch file (using some commands I have forgotten) to start the initial app, but I have a feeling there's a way to do it inside VFP9SP2 - or maybe with a dll? Any suggestions? Steve Tag: Network Workstation Q. Tag: 241445
  - 9
    - ActiveX Control No Visible After Form INIT Hi I have an ActiveX form on my form and despite my best attempts I cannot get the thing to display when I launch my form. The only way to 'fudge' the situation is to make it tab order 1 and force a 'TAB' character into the keyboard buffer. That's fine whilst it's the first control on the form but that's not always the case. I've seen this behaviour before with other ActiveX controls so it's not just confined to this one. I've tried: _VFP.AutoYield = .f. (program startup & form init) DOEVENTS ThisForm.Paint ThisForm.Refresh Have also tried the refresh(), redraw() events of the control but nothing works unless UNTIL the control gets the focus. Just wondered if anyone else had seen similar behaviour? Tag: Network Workstation Q. Tag: 241439
  - 10
    - Http post Group, We need to use Http Post to send a file (I have Zero experience with it) from vfp 6 to an electronic medical claims site for processing. They sent me the 'parameters', etc. but after googling for info, I found no examples of how to do it. Can anyone point me in the right direction? I don't know Http post from a fence post. TIA, Wade Tag: Network Workstation Q. Tag: 241435
  - 11
    - empty memo field in an sql query Hi and thanks in advance for the help... When doing an SQL query I've often used things like... space(2) as State or 000000.00 as Amount is there a construct that I can use in a query to create a memo field in the resulting table? Thanks, Jeff Tag: Network Workstation Q. Tag: 241425
  - 12
    - rename and rename table How can I rename tables in a dbc so that the disk name and the dbcname are updated and the backlink unbroken? Tag: Network Workstation Q. Tag: 241417
  - 13
    - Slider control... Does anyone know of a good 'slider' type control (other than the one in the "solutions" example) that I can use to change the size of my form? ________________________ | | | | | | | | | | | B | | | | | A | ____________| | | | | | | | | C | | | | | | | |__________ | ____________| The form is split in to three sections as shown above and I would like the user to be able to resize each by using the horizontal / vertical lines that separate the three panels A,B & C. Thanks in advance. Tag: Network Workstation Q. Tag: 241415
  - 14
    - VFP - Linux? I would like to run a Foxpro COM server (9.0 sp1) on a Linux server. How could that be done? TIA Tag: Network Workstation Q. Tag: 241399
  - 15
    - Bulleted lists in rich text format I'm trying to write a script that auto-generates RTF documents, and i would like to know how to create a bulleted list using raw rtf commands. Also, is there a good usenet group for RTF discussion? Thanks. Addison Tag: Network Workstation Q. Tag: 241397
  - 16
    - Storing Excel, Word and other data in VFP Time has come that my customer asks me to store some Excel sheets, some Word documents, some text files and some pictures into VFP itself. Time ago, there was OLE, so I could embed or just link the file into a "general" field. But I was warned in many articles on the web not to use general fields. So my question is: what else can I use? Blob fields? What happens if the worksheet or text file changes from outside VFP? What is the best way to handle such a situation? Walter Tag: Network Workstation Q. Tag: 241393
  - 17
    - ADir Command Hi, I'm using the ADir command to list files to an array. It's possible to list only the files updated 5 days ago and not all the files? Thanks. Ilidio Pedrosa. Tag: Network Workstation Q. Tag: 241389
  - 18
    - How to prevent creating a big exe file. In a project having some big readonly tables I build a DLL including this tables with a class to open them. This DLL is called mdata.DLL All was fine working in the VFP IDE but when I build the main project in which these tables are used I realized that the exe file is very big and include all mdata.DLL on it. 130 Mbs. I do this because I need to encrypt these tables and the tools I had used don´t work now in VFP9 in windows vista. I use Netlib and now Cryptor4. As I dont have Cryptor5 license I choose this way to protect the tables. Can I create an exe with the readonly tables in other .DLL file? Thanks. Alejandro Fernandez Tag: Network Workstation Q. Tag: 241388
  - 19
    - user-defined toolbar I am trying to allow users to customize a toolbar for an application. The toolbar settings would be stored in a database and read in at run time. A toolbar is easy enough to set up when it is predefined, but I'm having trouble figuring out how to do it dynamically. Should I try to set up a control array (if so, how do you do that within a class definition?) or should I do it some other way? Any help would be appreciated. Regards, Kevin Clark Tag: Network Workstation Q. Tag: 241379
  - 20
    - Report printing Hello We use Fox 2.6 to create our Purchase Orders. What I am trying to do is have one copy of the P.O. printed locally (to the default printer) and another copy go to a printer connected to a networked PC in another part of our building. I need to do this in code. Any help appreciated. Tag: Network Workstation Q. Tag: 241377
  - 21
    - VFP + MySQL Server foto exchange hy, i need programming code, i trying select foto from mysql into client program FoxPro,but nothing. Tag: Network Workstation Q. Tag: 241373
  - 22
    - TEXBOX Hi to All, I've already post this question, but I can't find it. My Question: If the user inputed on a Textbox 5x5 or 5*5 the result is 25. Maybe this very simple. Any idea please help me. Thanks for the help. Tag: Network Workstation Q. Tag: 241368
  - 23
    - Win7 & FoxPro What do you think? Can Win7 host FoxPro? Regards Tag: Network Workstation Q. Tag: 241366
  - 24
    - Control font when MODIFY MEMO I have an application where a principal functionality is involved with editing and reading MEMO entries in FoxPro tables. I've had mixed success with changing the font when within a MEMO field. I generally change the font from Courier to Arial, and from 8 point to 12 and like it like that. Sometimes when I go back into the table it retains those settings, but sometimes not. The application uses many tables (around 200). Is there some way I can get it to retain the settings for each table, or perhaps better yet, force Arial 12 point for all tables? Sometimes the MODI MEMO is issued from code, and sometimes I get into the memo fields by double clicking on Memo in a browse window. Dan Tag: Network Workstation Q. Tag: 241362
  - 25
    - DateTime() Q. I have a field that has the DATETIME() of the entry. How do I sql the datetime field for just the date and not the time portion? ie. SELECT * FROM xxx WHERE between(mydatetimeField,dateStart,dateStop) INTO TABLE .... Respectfully, Jonathan Morningstar Tag: Network Workstation Q. Tag: 241361

Can anyone tell me me how to return the Network and Workstation name off the
computer I am sitting at? Is there a SYS() command that will return that?

Cheers,
J Morningstar

Top

Re: Network Workstation Q. by Viorel

Viorel
Mon Jul 14 09:52:05 CDT 2008

Try

getenv("COMPUTERNAME")

Regards,

Viorel

"Jonathan Morningstar" <jm@ablecon.com> wrote in message
news:%23NrxAyb5IHA.300@TK2MSFTNGP05.phx.gbl...
> Can anyone tell me me how to return the Network and Workstation name off
> the computer I am sitting at? Is there a SYS() command that will return
> that?
>
> Cheers,
> J Morningstar
>

Top

Re: Network Workstation Q. by Fred

Fred
Mon Jul 14 09:58:34 CDT 2008

SYS(0) returns the workstation name and login name in this format:

"WS # Login"

--
Fred
Microsoft Visual FoxPro MVP

"Jonathan Morningstar" <jm@ablecon.com> wrote in message
news:%23NrxAyb5IHA.300@TK2MSFTNGP05.phx.gbl...
> Can anyone tell me me how to return the Network and Workstation name off
> the computer I am sitting at? Is there a SYS() command that will return
> that?
>
> Cheers,
> J Morningstar
>

Top