date time field to date

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
    - VFP6: SQL deadlock (1526) Still having a problem with inadvertent SQL deadlocks when I use my remote view. Can't nail down when/why. Is there any way to set the view read-only or prevent the deadlock with another SQL process? Or, what would be the best way to handle when I encounter this? Right now the program just stops. Thanks in advance for any advice. - Ben Tag: date time field to date Tag: 214816
  - 2
    - How to determine if an index tag exists Is there any way to determine if a specified index tag exists for any given alias? I have looked at KEYMATCH() but this needs you to know the index number. -- Kind regards Phil Hollingworth phil@wrltd.co.uk System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: date time field to date Tag: 214810
  - 3
    - specifying format in SQL Hello and thanks in advance for the help. How do you specify the format of a field in and SQL query? Example: I have a field called OPEN_BAL which is N (9,2). All values are > 0. I have another field called TRAN_TYPE which is C(1) and can have the value 'D' or 'C' For reporting purposes I need the 'C' types to subtract so I have a query: SELECT IIF(TRAN_TYPE = 'C', OPEN_BAL * -1, OPEN_BAL) AS OPEN_BAL.... This works fine except that the resulting field size in the query output is 9,2. If OPEN_BAL happens to be > 100,000.00 (example 123,456.78) the value will be -123,456.7. I need to tell the query to have the resulting field be N (10,2) so that it can accomodate the possible 6 digit number without losing a digit. Can someone tell me what I have to do to make this happen? Thanks, Jeff Tag: date time field to date Tag: 214809
  - 4
    - array[2,1] vs array[2] gotcha It turns out INSERT INTO <alias> FROM ARRAY <array> can insert more than 1 record. This is not documented and appears to be controlled by whether the array is dimensioned with 2D syntax or not. I'm sure it's old news but it had me scratching my head for a few minutes, thinking someone else's code was wrong. Then realising it was in fact working but I couldn't see why (he was selecting a field to an array so the DIMENSION clue wasn't visible.) CREATE CURSOR test (test C(10)) DIMENSION foo[2] foo[1]='record1' foo[2]='record2' ?foo[1] ?foo[2] * this inserts 'record1' only INSERT INTO test FROM ARRAY foo DIMENSION foo[2,1] ?foo[1] ?foo[2] * this inserts both records INSERT INTO test FROM ARRAY foo -- Regards Andrew Howell Tag: date time field to date Tag: 214807
  - 5
    - grid.column.textbox.valid() could lock focus A form with one commandbutton and a grid. Grid has one column. Column1.currentcontrolset is a textbox. Code in grid.column1.textbox.valid(): if empty(this.value) return .f. endif return .t. I found that whether the textbox.value is empty or not, the commandbutton could always be pressed. The textbox.valid() didn't stop textbox.lostfocus() from happening when the object clicked is a commandbutton. Why? And how could I prevent that? Tag: date time field to date Tag: 214796
  - 6
    - Transfering general data currently i can import image files to a general field, but how can i transfer from one field to another in different table ? transfer from TABLEA.GenFieldA to TABLEB.GenFieldB pls help. Tag: date time field to date Tag: 214795
  - 7
    - Error Handling I really like the TRY..CATCH, but I have a pretty good error handler build into my current large application. It writes to an ERRORLOG so I can check it every week for those errors the users never report. Should I leave the ON ERROR DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... in my current app, and then in the CATCH DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... or not even bother with it?? Thanks for your advice Tag: date time field to date Tag: 214791
  - 8
    - foxpro position avaliable around los angeles hi, looking for a foxpro middle level programmer, 2+ year experience would be good. job located around los angeles, interested party please call 626.964.8862 and ask for tony. Tag: date time field to date Tag: 214790
  - 9
    - Error Handling I really like the TRY..CATCH, but I have a pretty good error handler build into my current large application. It writes to an ERRORLOG so I can check it every week for those errors the users never report. Should I leave the ON ERROR DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... in my current app, and then in the CATCH DO ErrorHandler WITH ERROR(),PROGRAM(),LINENO(1)... or not even bother with it?? Thanks for your advice Tag: date time field to date Tag: 214789
  - 10
    - Determine user's permissions on network server This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C59D95.3E62AFB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I need to find a way to determine a user's permissions on a network = folder. Specifically, I need to know if a user has more than list or = read-only access to a know folder. Our servers are running Win2000 = server or Win2003, the work stations are running XP. I'm still = developing with VFP5. Thanks in advance. Steve ------=_NextPart_000_0013_01C59D95.3E62AFB0 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.2668" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Comic Sans MS" size=3D2>I need to find a way to = determine a=20 user's permissions on a network folder.  Specifically, I need to = know if a=20 user has more than list or read-only access to a know folder.  Our = servers=20 are running Win2000 server or Win2003, the work stations are running = XP. =20 I'm still developing with VFP5.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Thanks in = advance.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" = size=3D2>Steve</FONT></DIV></BODY></HTML> ------=_NextPart_000_0013_01C59D95.3E62AFB0-- Tag: date time field to date Tag: 214784
  - 11
    - Determine if CD Drive is Writable This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C59D94.12AA79D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm using the Win32 API to determine all of the logical drives on a = computer. I am able to get nearly all the information I need. The one = piece of info I am having trouble finding is whether a CD drive is = writable. =20 Thanks in advance. Steve ------=_NextPart_000_000A_01C59D94.12AA79D0 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.2668" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Comic Sans MS" size=3D2>I'm using the Win32 API to = determine all=20 of the logical drives on a computer.  I am able to get nearly all = the=20 information I need.  The one piece of info I am having trouble=20 finding is whether a CD drive is writable.  =20 </FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Thanks in = advance.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" = size=3D2>Steve</FONT></DIV></BODY></HTML> ------=_NextPart_000_000A_01C59D94.12AA79D0-- Tag: date time field to date Tag: 214783
  - 12
    - FPW2.6a @...SAY won't update when I want it to I've mentioned this before but this time it's the subject and it's really annoying me. I have a progress bar / thermometer drawn in nice old fashioned @...SAY and it will *NOT* update the screen when I want it to. Pseudocode looks like this ************************** FOR x=1 TO lots * do stuff * update progress bar NEXT x @...SAY 'Finishing off' SELECT <cursor> DELETE <expression that takes a while> SELECT <query that takes a while> ************************** What is so annoying is that the screen sits there showing "processing (lots-1) of lots" and then 'Finishing off' will be printed on the screen AFTER the DELETE command has finished. I have put 100 SHOW GETS, 100 @...SAYs interspersed with 100 SHOW WINDOW ... REFRESH in between "@...SAY 'Finishing off'" and the "SELECT <cursor>" and it makes no difference. The similar thing I've come across before is in a screen by the screen designer and 2 SHOW GETS seems to work for that. Is there any way I can make it work how I want? -- TIA Andrew Howell Tag: date time field to date Tag: 214781
  - 13
    - Multienvironmentproblem VFP8-SP1 Hi all! 1 User A deletes an row in a grid with a local view as its source DELETE IN 'vwSeverelGrdVals' tableupdate(1,.T.,'vwSeverelGrdVals') && returns .T. 2 User B changes the value of the same gridrow (she doesn´t see it is deleted) tableupdate(1,.T.,'vwSeverelGrdVals') && returns .T. ... requery('vwSeverelGrdVals') && causes an updateconflict How can tableupdate return .T. when the record doesn´t exist? The updateconflict arize even after a tablerevert - why? Best regards Christina Tag: date time field to date Tag: 214780
  - 14
    - Excel Print Area Hello, i have created an excell sheet by code with Visual Fox Pro. everything is fine with one exception. i have set the print area to be a certain size, but my data wcould be larger than that, so when it prints i get the last page cut off. osheet.pagesetup.printarea = "$A$1:I$166" is there a way to have the sheet or workbook print area shrink or grow depending on the data? Tag: date time field to date Tag: 214779
  - 15
    - acquired documents from scanner Hi, Are there any recommendations on this topic ? There seems to be "lots" of hits on a google search and I was wondering if someone has some experience with this. It should be able to grap one or more documents, if possible over LAN all from within my app. (Also prices ranges from around 40$ to 400$ ?!?) Thanks in advance regards christophe -- \|||/ (o o) ----ooO-(_)-Ooo------------- Tag: date time field to date Tag: 214775
  - 16
    - Slow screen repainting Hi, There are numerous situations throughout our VFP9 application where repainting of the screen is slow. Examples : 1. a form is shown (eg. a progress-bar form) and then heavy processing immediately occurs (such as retrieving data from SQLServer). A grey block is shown on the screen where the form is, the form is eventually painted some time later when Foxpro is not so busy. 2. a form is closed and then heavy processing occurs. A grey block is shown where the form used to be and the underlying screen area is not repainted until later. The forms are created via createobject() and then displayed using "oform.show", rather than "do form". I have tried "oform.refresh" after the "oform.show" but this doesn't help. I don't remember having this problem back in VFP 6; the issue has existed in all subsequent versions of Foxpro. Is there any VFP setting, or WinAPI call, that will force the screen to repainted immediately? Other suggestions? Thanks. Paul Elliott Tag: date time field to date Tag: 214767
  - 17
    - index expression for the current tag() How could I know the index expression for the currently select tag? sys(14) requires an index number as an argument. However there is no function to determine the index number of the currently active tag. tag() returns the name only. Tag: date time field to date Tag: 214764
  - 18
    - [OT] User-Defined string Functions Transact-SQL Ladies and Gentlemen, I am pleased to offer, free of charge, the following string functions Transact-SQL: AT(): Returns the beginning numeric position of the nth occurrence of a character expression within another character expression, counting from the leftmost character. RAT(): Returns the numeric position of the last (rightmost) occurrence of a character string within another character string. OCCURS(): Returns the number of times a character expression occurs within another character expression (including overlaps). OCCURS2(): Returns the number of times a character expression occurs within another character expression (excluding overlaps). PADL(): Returns a string from an expression, padded with spaces or characters to a specified length on the left side. PADR(): Returns a string from an expression, padded with spaces or characters to a specified length on the right side. PADC(): Returns a string from an expression, padded with spaces or characters to a specified length on the both sides. CHRTRAN(): Replaces each character in a character expression that matches a character in a second character expression with the corresponding character in a third character expression. STRTRAN(): Searches a character expression for occurrences of a second character expression, and then replaces each occurrence with a third character expression. Unlike a built-in function Replace, STRTRAN has three additional parameters. STRFILTER(): Removes all characters from a string except those specified. GETWORDCOUNT(): Counts the words in a string. GETWORDNUM(): Returns a specified word from a string. PROPER(): Returns from a character expression a string capitalized as appropriate for proper names. RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right search. ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified numeric expression (from 1 to 3999). ROMANTOARAB(): Returns the number equivalent of a specified character Roman numeral expression (from I to MMMCMXCIX). AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL INSTR, LPAD, RPAD, TRANSLATE, INITCAP. More than 4000 people have already downloaded my functions. I hope you will find them useful as well. For more information about string UDFs Transact-SQL please visit the http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115 or http://nikiforov.developpez.com/ (the beautiful French language) Please, download the file http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115 With the best regards. Tag: date time field to date Tag: 214763
  - 19
    - FoxPro through ODBC datatype Hi, I am using InteropServices to connect to FoxPro using ODBC but I am having a problem with the data type return from SQLAllocHandle as I, C, T, etc. Why does it so and where can I find the comprehensive list of datatype mapping and conversion for FoxPro? Thank you in advance, Sunny Tag: date time field to date Tag: 214760
  - 20
    - can't find my dll I created a com dll in foxpro 9. I registered it and tested it using createobject and everything works fine. I then created a form and try to put an OLE object on it. When the control list came up, I couldn't find my dll. I clicked on the add control button and found my file and it still did not show up in the list. I can get everything to work fine with the createobject but I would like to have the advantage of intellisense when I am using this. -- TIA Altman VFP9 Tag: date time field to date Tag: 214750
  - 21
    - xml can anyone provide any help or hints ? the following code produces nothing; no error msg and no results and llOK is true oXml = createobject("xmladapter") oXml.xmlSchemaLocation = "sage.xsd" llOK = oXml.LoadXml("10712478.xml",.t.) attached are the (small) sage.xsd and 10712478.xml files generated by a ecommerce site for our customers I am using vfp 8, sp1 thanks for any help al Tag: date time field to date Tag: 214748
  - 22
    - 9.0 Report writer - is it possible Hi, Is it possible and if yes how to create multiple columns in the detail band only? Example layout. print sales order with detail lines and the box weights in columns. files so_maste, so_detail, so_boxes relations and skip is set as follows so-master so_detail so_boxes All I seem to be able to get is a report looking like this So_master info in the page header so_detail line in the group header by sono boxweight boxweight boxweight etc .... What I would like to get is So_master info in the page header so_detail line in the group header by sono boxweight boxweight boxweiht ......... The only way I seem to be able to do that is looping through the box file programmatically and building a string and taking care of the line brakes and the allignment based on font myself TIA Tag: date time field to date Tag: 214747
  - 23
    - Xsource and the label wizard VFP6 SP5 Through Xsource I can find the source code for the report wizard, but I can't find the source for the label wizard. Does it exist, I can see everything else. Tag: date time field to date Tag: 214719
  - 24
    - Number of Filtered results Is there a way to get the number of records that a SET FILTER command returns? Thanks for the help Tag: date time field to date Tag: 214710
  - 25
    - Stringing together IIF's i am trying to string together these IIF's. i am gettng "Function missing ) " but i guess i cant see it. myfunction(from)+iif(left(from,1)=".",""," iif(left(from,1)="",".","")â??) Tag: date time field to date Tag: 214699
- Next
  - 1
    - FPW2.6 COMMAND= and standalone .exe I'm trying to stop the macro dialogue from showing. This can be achieved with the command SET MACKEY TO. I tried entering MACKEY="" in the config.fpw but to no avail so I tried using COMMAND=SET MACKEY TO. That is when I found an unfortunate side effect: If I use a COMMAND= in the config.fpw of a standalone .exe, it runs that command and immediately exits rather than running my application. I'm guessing a standalone .exe starts up Foxpro from the .esl then has something like a DO <topprog> where topprog is the top program in the project. Any other ideas why this effect is seen? Or how to suppress the macro dialogue from the config? If it's not possible I'll just put the command in all the applications' top level program. -- TIA Andrew Howell Tag: date time field to date Tag: 214696
  - 2
    - Hot to get Remote computer Hard Disk Serial No How to get the Remote computer hard disk serial no, example from Workstation PC to get the SERVER PC serial hard disk Thank you. Tag: date time field to date Tag: 214695
  - 3
    - vFP 9 and XP Pro 64 I'm having problems installing vfp9 on XP Pro 64 bit version. In the beginning when it wants to install prerequisites it will not install setup runtime files. Any ideas on this? Tag: date time field to date Tag: 214678
  - 4
    - Mouseover Problem in Windows XP .. I am working on an application containing some old fashioned code involving input through say/get which is not compatible with windows XP and windows 2003. I want to convert this code in a way that it 1: does not causes 'the mousever problem', and 2: supports Windows XP themes. My biggest worry is how to convert the code defined as 1: a Windows is created and then numerous say/get commands follow. 2: some menu pads - to be converted to command buttons - follow to initiate the action. This sort of code is placed in some over a dozen places in the application - which uses accpac pro framework -. How can I convert such code to use a Form and command buttons. Please advise .. one way of doing this is to have a generic class and populate it at run time but am not sure how am I going to do it. Tag: date time field to date Tag: 214675
  - 5
    - Rick Strahl at LA Fox August 9 Rick Strahl is our distinguished speaker this month at LA Fox. He'll be speaking on Integrating Internet Electronic Payment Processing into Web Applications. "This session will guide you through the maze of choices for collecting payments from your customers online. We'll start by discussing the business end and understanding of how gateway services, merchant providers interact and how you can get your payments processed over the Internet. You'll see the architecture and different approaches from several common providers including Authorize.NET, Verisign PayFlow, LinkPoint and AccessPoint as well as Paypal. Then we'll demonstrate and differentiate the various vendor APIs and provide a common framework of classes for managing multiple providers efficiently in your applications. Finally we'll put it all together in a demo application that demonstrates the credit card processing for multiple providers managed in both an Web Connection front end application and a Desktop application." Come see why Rick is one of our most popular speakers! For further details or directions, please see our UG web site at http://www.lafox.org. See you there! Bill Anderson Tag: date time field to date Tag: 214656
  - 6
    - Boot Camp VI details posted! The Los Angeles Visual Foxpro Developers Group has posted the details on Boot Camp VI. The all day event will be held on Saturday, September 24. Topics will be presented by Marcia Akins and Andy Kramek. This is a great value!!!! Five different sessions presented by talented speakers at the low, low price of $99.00. The topics are: 1. Optimizing Your Code 2. Event Handling in Visual FoxPro 3. Data Buffering and Transactions 4. Modeling Hierarchies 5. Introduction to the Visual FoxPro 9 Report Writer Details on these sessions can be found at <http://www.lafox.org/newsletter/bootcamp6.htm> We look forward to seeing you there! If you have any further questions, feel free to contact me at bill@lafox.org. Bill Anderson Tag: date time field to date Tag: 214655
  - 7
    - Have all Fox versions since 2.6, EXCEPT VFP 8.0. Should I get 8? Until last night, I had everything up to and including 7.0. I have been investigating getting 8.0 and 9.0, maybe getting some kind of MSDN subscription or an ISV arrangement. I got lucky at a Fox user group last night and won the raffle and got a copy of VFP 9.0 (on a DVD with 7.0) and some other MSDN stuff from March 2005. What I know about VFP 8.0 and 9.0 is pretty much what I've picked up just going to various VFP user group meetings and a few presentations by VFP gurus (Drew Speedie among them). Virtually all of these meetings have presentations by very knowledgeable VFP people, however, my knowledge is necessarily spotty. I'm wondering if and how much I'll miss not having 8.0. I'm looking for FoxPro work. I've heard that most of the major changes in VFP in a long time came in version 8.0. Does 9.0 have everything I need to get up to speed? Or does 8.0 have examples/samples, etc. that I won't find on that MSDN DVD (Disc 2488.2, March 2005)? Thanks! Dan PS: I just went to the Universal Thread and looked for the Fox chat area and couldn't find it. Did they do away with that? Tag: date time field to date Tag: 214651
  - 8
    - vfp7 vs vfp9 Thanks, the problem was solved with your info. Tag: date time field to date Tag: 214650
  - 9
    - Special Characters Set Hello all, Working with foxpro for DOS, I can insert into a program a special character such as a <smily face>. If I do open that program into visual foxpro (windows) what I see is a totally different character. If there's something to do to set the character set in windows so when I do open the program in vfp to see the same <smily face> what would that be? Thank you all Tag: date time field to date Tag: 214640
  - 10
    - close application from windows 'X' button I wrote a simple application in Visual Foxpro 8 for the pourpose of viewing/exporting firewall logs. When I close the application through the Windows X button (next to Minimize and Maximize) I get the message "Cannot quit Visual Foxpro". I have an Exit command in my file menu and I set that to the command CLEAR EVENTS and this works. If I put ON SHUTDOWN CLEAR EVENTS in my main program and then click the Windows X button, the program seems to go into an infinite loop and the only way to close it is to kill the process. Thanks in advance Henri Visser Tag: date time field to date Tag: 214629
  - 11
    - List Box Help i have a very simple form with a List box, that shows a field in a Table. and exit button and a "ADD" button. i would like the list box to refresh as the add button is pressed with a new word. i can get the list slide to move, and a blank space for the name just entered but it wont show it, only after i close the form and re-open it. below is my code in the 'ADD' button. select newword append blank replace word with m.text1 thisform.text1.value = " " thisform.list1.additem(m.text1) thisform.list1.refresh Tag: date time field to date Tag: 214628
  - 12
    - tables on desktop On occasion vfp8 tables with index and memo files appear on the desktop. I don't know why they are showing up there. I can delete them with no problem. How to stop this weird behavier? thanks sherry Tag: date time field to date Tag: 214623
  - 13
    - Form not getting invisible! Hi, I put the property in the form Visible=.F. , but still the form is visible. Is there some other property I have to check? Thanks in advance. Derek Tag: date time field to date Tag: 214615
  - 14
    - Cursor Adaptor SP timeout I have a cursor adaptor executing a sql server stored procedure. In query analyzer it executes in about a second and returns about 90 rows. In foxpro the cursor adaptor returns a timeout. If executed with different parameters it returns less rows and doesn't timeout. What could be causing this? And how do I play with timeout settings for cursor adaptors? VFP 8.0 / MSDE 2000 8.0 TIA LH Tag: date time field to date Tag: 214614
  - 15
    - VFP6: SQL Correlated Query Problem Why does the following query not work? I get an error of "SQL: Error correlating fields.". select wo1.* from cwko wo1; where; wo1.isgwo and wo1.wostatus#"V" and exists; (; select wo2.wonbr from cwko wo2; where; wo2.wonbr#wo1.wonbr and wo2.isgwo and wo2.wostatus#"V" and; (; (wo2.trndtlow between wo1.trndtlow and wo1.trndthi) or; (wo2.trndthi between wo1.trndtlow and wo1.trndthi) or; (wo2.trndtlow<wo1.trndtlow and wo2.trndthi>wo1.trndthi); ); ); order by wo1.clcode,wo1.wonbr I am looking for the work orders that are GWOs, are not void, and where there is another such work order such that their trndtlow to trndthi date ranges overlap. I have tried several variations to no avail. Sincerely, Gene Wirchenko Tag: date time field to date Tag: 214613
  - 16
    - Message Box I need to display a messagebox for a system using 2 monitors. I need to use Version 7 of Fox. The Messagebox() function automatically puts the message in the center of the screen whichs ends up 1/2 on each physical screen. Very pain-in-the-butt. How can I use a windows function where I have control of where to put the message? Or can I? Thanks Tag: date time field to date Tag: 214600
  - 17
    - RUN command for file name with space Hello, I have to open an excel file using RUN command, but the file name contain space. Any idea how this file can be open using VFP6? Thanks, Mark Tag: date time field to date Tag: 214594
  - 18
    - BarCode 39 I use barcode 39 very well, However, it seems that cannot read "space" e.g 123(space)459 So, any character I need to replace and make the barcode reader can read it ??? Thanks a lot. Tag: date time field to date Tag: 214586
  - 19
    - Excel language I have an application in VFP8 which creates Excel sheets. I use some simple VB commands like Select,Range,Value,Font itc. Several users use this application. But some users have Excel in English, the others have translated Excel version/Hungarian/. My program does not work with Hungarian Excel. Is it possible to find out what Excel version is installed on the user's PC using VFP? -- Sandor Tag: date time field to date Tag: 214585
  - 20
    - How to create a COM object with events feature? Hi I am using VFP8 and like to create a COM server object that is capable of raising an events. The client application will call a method in the object and the COM object will feedback the client the result via events. I read the MSDN but do not understand how to do it. Can anyone show me a sample code how this can be done? Appreciate your help. Thank you. Regards Tham Tag: date time field to date Tag: 214578
  - 21
    - preview and then select printer I want to preview the report and , then the user press'print' . However, print will let the user choose the printer directly. but not 'print directly' I know it may impossible . Anyway, Can I do that ?? Thanks a lot. Tag: date time field to date Tag: 214574
  - 22
    - vfp 7 Vs vfp9 i hava application runing allready in visual fox 7, i buy the visual fox 9 these is en english because the dealer rell me the only languaje availble was english but when i do the follow instruction i get the result in english CDOW(DATE()), my windows xp prof is in spanish and all the regional and language options are for the spanish. Thanks for the help. Tag: date time field to date Tag: 214572
  - 23
    - move from visual 7 to visual 9 I develop application and is workig inm visual 7 i allready buy the visual 9 and the application send an error in the instruction SELECT WITH SUM AND GROUP BY I will appreciate if could you help me. Thanks. Armando Villa Tag: date time field to date Tag: 214566
  - 24
    - VFP sqlexec I have a odbc connection to an IBM DB2 database I could use all the SQL commands however the SQLEXEC return -1 Aron Tag: date time field to date Tag: 214565
  - 25
    - Mouse and keyboard in dropdown box I have noticed in FoxPro that when you have a drop-down combo box, the highlighted item in the box changes if you move the mouse over the combo without clicking. The problem I have found is that if a person clicks a drop-down box down and then leaves the mouse within the drop-down box, they cannot use the up and down arrow keys anymore. Whenever the user presses the up or down arrow keys, the highlight will momentarily change to a new item, but then it immediately goes back to the line that the mouse is over. Is there any way to disable the mouse rollover changing the highlighted combobox item so that the user could use the keyboard? Kevin Clark Seton Home Study School Tag: date time field to date Tag: 214557

Dear All,

Would anyone tell me how to convert date time field to date field.

thanks in advance

wa

Re: date time field to date by Villi

Villi
Fri Aug 12 01:30:55 CDT 2005

Mi e' parso che Ah Wa abbia scritto:

> Dear All,
>
> Would anyone tell me how to convert date time field to
> date field.
>
> thanks in advance

datevar = ttod(datetimeVar)
--
The answer to the ethernal question is:
put a read events after the launch of the form

Top

Re: date time field to date by Ah

Ah
Fri Aug 12 01:44:18 CDT 2005

Thank you very much!!
"Villi Bernaroli" <a@b.c> ¦b¶l¥ó
news:%23v91mdwnFHA.3564@tk2msftngp13.phx.gbl ¤¤¼¶¼g...
> Mi e' parso che Ah Wa abbia scritto:
>
> > Dear All,
> >
> > Would anyone tell me how to convert date time field to
> > date field.
> >
> > thanks in advance
>
> datevar = ttod(datetimeVar)
> --
> The answer to the ethernal question is:
> put a read events after the launch of the form
>
>

Top

Re: date time field to date by christophe

christophe
Fri Aug 12 01:47:50 CDT 2005

date = TtoD(datetime)

or if you really mean a field from a table
just change your table field with Modi Struct

--
\|||/
(o o)
----ooO-(_)-Ooo-------------

"Ah Wa" <cpcpwy@ahwa.net> schreef in bericht
news:uS07dNwnFHA.2916@TK2MSFTNGP14.phx.gbl...
> Dear All,
>
> Would anyone tell me how to convert date time field to date field.
>
> thanks in advance
>
> wa
>
>

Top