empty date insert into 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
    - Macro: Swap lines Hey guys, found these macros interesting and time saving: To add them go to tools/macros/new CTRL+UPARROW : {HOME}{SHIFT+DNARROW}{CTRL+X}{HOME}{UPARROW}{CTRL+V}{UPARROW} CTRL+DNARROW : {HOME}{SHIFT+DNARROW}{CTRL+X}{HOME}{DNARROW}{CTRL+V}{UPARROW} Have fun! PS. if you don't want to overwrite the functionality of CTRL+UPARROW or CTRL+DNARROW you can use ALT+1 and ALT+2 or whatever other keys you feel more comfortable ;-) Tag: empty date insert into table Tag: 188915
  - 2
    - Quicken API? Do I remember someone saying that this is available? Has anyone used it? Is it easy to use from VFP? Fits in well? Regards Mark Tag: empty date insert into table Tag: 188912
  - 3
    - Grid columns and subclasses I know I can drop a base class into a grid column, e.g. a command button, and it's useable in design time, but is there a way to do this if I've subclassed it? I've tried using the class browser (VFP7/8) but it doesn't want to work for me. I can add the object at runtime with AddObject, but I'd like access to all the good Intellisense prompting during design if possible - it makes everything so much easier. Grateful if anyone can help. Regards, Neil Tag: empty date insert into table Tag: 188908
  - 4
    - Unusual Report Problem Any help or suggestions appreciated, thanks in advance. I have the following problem with report printing. To keep this post short I'm going to use meta code: Get a List of Clients to Print Reports For (SQL Query) For Each Client Get a list of detail items for report (SQL Query) Report Form xxx to Print NoConsole End For This code is being called from within a form. I first tried putting the code into a user defined method within the form itself. When I started having problems I took the code out of the form and put it into a separate PRG. The problem is as follows: The first time the report is run (for the first client) I get a "Variable Not Found" error from the report itself and the detail lines of the report do not print. Each of the following reports print perfectly. Here's the strange part: If I run the prg from the command window instead of from the form all of the reports print correct or If I run the prg from the form with the debugger on all of the reports print correctly It is only when I run the prg from the form without the debugger that I have a problem One last piece of data on this problems (to add to the strangeness) The form is a top-level form with a menu. When the report code is run from the menu as described above the problem occurs. When I put a button on the form which calls the identical code (the above mentioned prg which is outside the form) it runs perfectly. The button is my temporary work-around for this problem but I would like to be able to get this code to run from the menu. Does anyone have any idea what type of problem I am looking at? Thanks again, Jeff Tag: empty date insert into table Tag: 188898
  - 5
    - Creating a new database with copies of old tables Is there a way to create a new database, and copy the tables from another database into this new database with out truncating the field names or any other strange problems? we have a dev db and a live db, when we use ten dev system they db's are linked still back to live ... if we change the database name, we think that it would fix the linking problem, but we need to move the tables into this new db to do that, we think.. does anyone have any idea's? thanks! Tag: empty date insert into table Tag: 188890
  - 6
    - Order by with a union I have a comboBox with an sql statement that has 2 fields in it both of them are shown in the dropdown. I want it to sort by the description (2nd field). My sql statement has a UNION in it so that I can have a blank record for the user to choose from. This cuases problems though when I want to order by description because it gives me an error "order by clause is invalid" Any ideas how I can have a blank record and still order by description??? Tag: empty date insert into table Tag: 188886
  - 7
    - Newbie question - closing a form I am having problems closing a form through Code. I want a form to pop up during a certain position in code and close at a certain position. I used Open form XXXX to temp and then setting temp to .T. when I want it to stop, but I get an error saying something about modal forms. HELP ME PLEASE!!! Tag: empty date insert into table Tag: 188883
  - 8
    - Testing Newpost I'm just seeing if I can create a new post. I've been having trouble ever since the web site layout was changed, and I must say I liked the old layout better. At first clicking reply or new opened a window that could not find page. Now, it appears to work when I reply, but the reply is never posted. I've waited days to see if it would post. Right now I'm wandering it new post is going to actually post or be another dud John B. Tag: empty date insert into table Tag: 188882
  - 9
    - Reports Not Printing Hello All, We created a FoxPro application that ships with about a dozen reports. All of them print correctly most of the time, however one of the reports does not always print. In some cases, only the header prints and nothing else. The strange thing is, it is not limited to a particular hardware configuration. On some machines it always prints. On some machines it never prints. And on some machines it sometimes prints. On the development machine in particular, it prints every time. The report consists of a header with 6 text fields and a detail band with a text field that stretches with content to create paragraphs. It was created in MS VFP 8 SP1. Any advise would be greatly appreciated. Thanks in advance, Royce Tag: empty date insert into table Tag: 188881
  - 10
    - VFP 6 unexpected Printer is not ready messages I have a batch process running perfectly happily on computers in London, it writes to a log file so that I can see what it's done using procedure logFil logFilePathAndName= "s:\logfile.txt (s:\ is mapped network drive to server when all data is kept set printer to &logFilePathandName additiv ??? "Print log message set printer t The data is accessed with no problems and most of the time it writes to logFile with no problems, but just once of twice each run, in different places, it throws error 125 "Printer is not ready" on retry it goes ahead and prints The only difference I know about is that the machines that the program runs on are Windows XP where the ones in London are 2000. Does anyone know of problems with using VFP6 in XP? Tag: empty date insert into table Tag: 188873
  - 11
    - Remote process in VFP 8 Hi. I would like to run a process on a remote computer (in the LAN) to get its system time in order to synchronize the system clocks in the network. Any ideas how to do this in VFP? Krister Tag: empty date insert into table Tag: 188861
  - 12
    - grid question Dear All, Is this not possible doing in grid? grid.recordsource = "select lastname + space(1) + othername as fullname from customer" I got the records show up in a flash, and display nothing after that. but when i set recordsource like this = "select lastname, othername from customer" it has no display problem at all. Many thanks. Regards, Wandy Tang Tag: empty date insert into table Tag: 188859
  - 13
    - Parameters Question Hi, Is there a way to know the whole list of parameters (as an array ?) passed to a VFP executable? Something similar to the argv[] of C language. Demetrios, Greece Tag: empty date insert into table Tag: 188850
  - 14
    - Alias not found When I run this program, SET CENTURY ON SET TABLEVALIDATE TO 0 SELECT SELECT() USE "C:\FOSSEURO\TEMPFATT" EXCLUSIVE NOUPDATE SCATTER MEMVAR NAME oFT USE "C:\FOSSEURO\FOPRINT" EXCLUSIVE * clean the dbf SET SAFETY OFF ZAP SET SAFETY ON * imposta il nuovo record SCATTER MEMVAR NAME oFO BLANK * nfattura IF oFT.SUBFATTURA <= 0 && <<<<<<<<<<<< Error line oFO.NFATTURA = TRANSFORM(oFT.NFATTURA, "99999999") ELSE oFO.NFATTURA = TRANSFORM(oFT.NFATTURA, "99999")+"/"+TRANSFORM(oFT.SUBFATTURA, "@B 99") ENDIF ... at the line 'IF oFT.SUBFATTURA' the error 'Alias not found is showed'. With debug I see objects oFT and oFO were not created by VFP. Try to add oFT = CreateObject("Empty") without results. What mistake I made ? Thank you. -- ====================================================== BELLANTONE MAURIZIO - Teacher Istituto Tecnico Industriale Statale 'Ascanio SOBRERO' Via Candiani D'Olivola 19 15033 CASALE MONFERRATO (AL) - ITALY ------------------------------------------------------------- E-mail: bellantone@libero.it ====================================================== Tag: empty date insert into table Tag: 188849
  - 15
    - how to determine if Memo field Guys, Is there a way to determine if a give field is a memo field or not. (I do not want to use AFIELDS(), as this requires creating an array & keeping it in the memory) -- Besty Regards, Thilaka Tag: empty date insert into table Tag: 188846
  - 16
    - runtime dll files like vbrun dll files for foxpro If you want to make one screen and table and make an excutable file, VFP exe file would exceed 3mb Is there not any way that commonly used dll files can be downloded as free download from microsoft site, lik it is doe for visual basic? Thus reducing the sie of distributable files Does anybody knwo why it is not done Tag: empty date insert into table Tag: 188840
  - 17
    - set filter hi all, what i'm trying to achieve now is synchronizing two grids. the afterrowcolchange() method of grid 1 will invoke the refresh() method of grid 2, which is to retrieve certain database fields from the database based on d selected row of grid 1 i used SET FILTER TO conno = combo.cnum IN ConsigneeDetails, where combo is a cursor in grid 1's refresh() method however, i get an error msg saying that alias "combo" cannot b found anyone has any idea wats wrong? pls help! th Tag: empty date insert into table Tag: 188839
  - 18
    - Printing Visual Foxpro Application Screens Hai I am in the process of studying an application which was developed in Visual Foxpro. I want to take Prints of all the Screen,UI's in the application n forms etc excluding Reports. I am not sure as how to get in to the process. plz Can anyone help me Anil Kumar Tag: empty date insert into table Tag: 188837
  - 19
    - Form resizing tool Has anyone used the VFP Resizer Tool from Toxtoolbox.com? Will it work with VFP 8.0? Thanks, John. http://www.foxtoolbox.com/GroupList.dbx?catkey=13 Tag: empty date insert into table Tag: 188834
  - 20
    - Updating Foxpro tables Hello, I am having trouble updating a foxpro table. I have created ADO connection and command variables. The table is linked to my MS Access database. The command is: UPDATE MBFIL1 SET Annivdt = #06/30/2005#,mbrpaid = 3 WHERE ID='029611' I get err.number, -2147467259, Operation must use an updateable query. What am I doing wrong? Thanks Tag: empty date insert into table Tag: 188824
  - 21
    - How to use SQLEXEC command ? Hi why if I write codes using SQLEXEC, VFP8 can not accept the codes because too long How should I do if I want to change my record in SQL2000 using sqlexe command Are there a detail sample for using SQL Server from VFP8 My codes like (below) tresult=SQLEXEC(tconnect,[UPDATE BDATA SET KD1=T1 NMESIN='xx1' WARNA='black' XTYPE='xx2' TAHUN=2003 SATUAN='pcs' MAINCD='01' SUBCD='01' FROM BDATA WHERE BDATA.KD1=XKD1] Many appreciate and thank's for your kind help Tag: empty date insert into table Tag: 188812
  - 22
    - Security Issue Hello Fox friends! 1) How do you handle security in Client/Server or in n-Tier App in VFP at front end and SQL server at back end. Is it ok to save password with connections? and then include database container files in project, so that other cannot modify it during runtime. 2) Can any one mention security break down risks in such projects? 3) Is oracle better than SQL server for security and performance issues for normal sized tables. Regards Imran Saroia Tag: empty date insert into table Tag: 188808
  - 23
    - passwordchar property of text box Hi! I am experiencing strange behaviour while using "passwordchar" poperty of text box. In most of the systems users can copy and past the text in text editors and word processing packages even if the Passwordchar is set to some characters like "*". This way they can hack the password. How to disable this hacking? This is being experienced in some systems (98/ME/NT). Tag: empty date insert into table Tag: 188807
  - 24
    - Writing to the registry VFP7SP1-W2K Hi all! If I by code write a characterstring containing chr(0) the chr(0) and the characters after chr(0) aren´t written to a registry key´s value. THISFORM._cryptapi.EncryptSessionBlockString('2453029','Scania ABUlf Ericsson',@lcEncryptedDay) puts a string containing chr(0) into the variable lcEncryptedDay. But WSHShell.RegWrite ("HKEY_CLASSES_ROOT\MyKeyName\",lcEncryptedDay) puts a string without chr(0) into the MyKeyName value. Furthermore, the characters after chr(0) are omited. If I use loRegistry.SetRegKey...(the registry class) instead of WSHShell.RegWrite the same thing happens. Is there a workaround for this behavior? Any help would be very appreciated. Regards Christina Tag: empty date insert into table Tag: 188801
  - 25
    - How to speed up accessing SQL2000? Hi there I try to compare the speed between VFP8 to SQL2000 Both of them proceed 200,000 records data but why VFP8 more faste rather than SQL2000 What's I want to know is which one of them more faster What's a better technique to read/write records from SQL2000 Is it my technique right/wrong I compared it with 1. check1=SQLEXEC(connect_ok,"{CALL sample1 ('12/31/03')}","result1" 2. Cursoradapter (ODBC 3. Native Vfp: select kd1,sum(total1) as total from data1 into cursor result1 group by kd1 where date1=ctod('12/31/03' Thanks alot all of your teach and kind infomation Tag: empty date insert into table Tag: 188799
- Next
  - 1
    - I need a justify text program. Hi there.. I need to justify some text in a VFP Report, text come from memo fields and is length variable, so a i need to justify it into 70 - 80 characters. Thanks for your help. Oscar Glez Hdez. Mexico City. Tag: empty date insert into table Tag: 188795
  - 2
    - Using FIELD() to get field contents in FoxPro2.6? Hi! In my program, I don't know the name of the field I want to modify, but I know it's number. I want to do this: FieldNo=2 REPL field(FieldNo) with field(FieldNo)+10 but of course it returns a syntax error, because field(FieldNo) returns the field name, not the contents. Please - does anyone know a way around this? Any ideas much appreciated!! Jason Tag: empty date insert into table Tag: 188794
  - 3
    - How to retrieve the value in a particular cell in a grid? Does anybody have any ideas for retrieving a value in a particular cell in a grid where the cell is not in the ActiveRow. In my case, I am trying to retrieve the value in cell(1,1) from within the Scrolled event. Currently I am using the ActivateCell method and storing it to a variable (called by the Scrolled event when the user scrolls). It works fine until the ActiveRow scrolls out of view Maybe I am looking at this incorrectly. My objective is to reset the pointer in the grid's RecordSource to that record displayed in the first row of the grid after the user scrolls. Anybody have any ideas Thanks. Tag: empty date insert into table Tag: 188788
  - 4
    - Using FPW 8 with a linux server. We have several installations of our software in vfp 8 running multi user on W2000 server installations. Data is on the server - each pc has the program. Works great. We have a customer who wants to put the data on a linux server. Any problems with linux servers and vfp8 multi-user? Anyone have experience with linux and vfp8 multi-user? Tag: empty date insert into table Tag: 188787
  - 5
    - Questions about VFP 8.0 What screen resolution do most developers use when creating a new form for distribution? I don't know if the user will have 640x480 or 1600x1200 resolution. Is there a simple way to enlarge obects and changes fonts on a form if the user wants to fill a 1200x1024 screen and the app was designed in 800x600? Where can I find the icon editor that supposedly came with VFP 8.0? When distributing a VFP app (I have professional edition), can my client re-distribute my app to his clients? Thanks in advance, John. Tag: empty date insert into table Tag: 188785
  - 6
    - Connecting to Network printer using VFP Hi, Can somebody please give me an example how to connect to the network printer (assuming that I am on the workstation and want to connect to server printer [one of the printers]) on Windows network, using AddPrinter(), OpenPrinter(), ClosePrinter() API from winspool.drv or similar. I know how to grab a local printer configured on the local machine (grab default from the registry) but have no idea how to do that over the network. Example for Local: lcPrinter = GetPrnName() hPrinter = 0 IF OpenPrinter(lcPrinter, @hPrinter, 0) = 0 ? "Unable to Retrive Printer Handle" RETURN ENDIF FUNCTION GetPrnName * returns default printer name from Windows Registry LOCAL lcBuffer, lcPrinter, lcDriver, lcPort lcBuffer = REPLICATE(CHR(0), 120) = GetProfileString("Windows", "Device", ",,,", ; @lcBuffer, LEN(lcBuffer)) lcBuffer = STRTRAN(lcBuffer, CHR(0), "") RETURN SUBSTR(lcBuffer, 1, AT(",", lcBuffer, 1) -1) ENDFUNC Could somebody, please, give me an example(s) or point me to the example(s) how to grab a network printer? Thank you in advance, Oleg Tag: empty date insert into table Tag: 188784
  - 7
    - Invalid VFP8R.DLL I made up an application into an exe file using Windows XP. If I load this program on an XP machine it runs fine. When I try loading the same program on a Windows 98 second edition or even try to run it from a work station on the network that uses Windows 98 I get the message "THE VFP8R.DLL file is invalid or damaged". Do I have to compile this program on a Windows 98 machine in order to run on it or can someone tell me the problem or what has to be done. This program worked fine when I made up the application use VFP6 on all machines. Is there a difference in the support programs? Thanks for any clues. Tony Tag: empty date insert into table Tag: 188776
  - 8
    - How to get machine name and ip address? I have a routine in an error handler that sends an email to admins when an error occurrs. The app is running on different boxes, and there is currently no way to determine which box is sending the error email. It would be convenient if I could include the machine name and ip address in the email. Is there an easy way to get this info from within VFP? Tag: empty date insert into table Tag: 188768
  - 9
    - XP questions Sometime, long ago, I found a solution to my questions by reading the threads, but I have been unsuccessful finding the answers on my own. Here goes. I have moved a v2.6 foxpro application to a XP system. Questions: 1)How do I enlarge the display? and 2) How do I direct output to a network printer. On one workstation the display window displays correctly without any action from me, on another workstation is window is very small. As far as the network printing, on the workstation that prints to a HPJ4 network printer, I have changed the printer to HPJ4, added an entry in config.fp "Printer=LPT1", under file->printer setup changed "print to:LPT1", "print on", etc. Yet, when the app sends a print request the machine sits seemingly idle for a very long time and returns to menu. Any thread or KB that solves this mystery would greatly be appreciated. Thanks, Blitz Tag: empty date insert into table Tag: 188760
  - 10
    - checkbox in grid won't accept input Hi all, I have a strange one and I've been banging my head against a brick wall. I have a grid with one column that I want to be a checkbox instead of a textbox, and I am having problems getting the thing to accept input. But ONLY IF I add it programmatically to the grid. If I add it visually it works fine. Here's the code I'm using to programmatically add the checkbox to the grid: lcCol = THISFORM.MyGrid.Column5 && my column I want the checkbox in &lcCol..AddObject('Chk1', 'checkbox') &lcCol..Text1.ReadOnly = .f. &lcCol..Text1.Enabled = .t. &lcCol..Chk1.ReadOnly = .F. &lcCol..Chk1.Enabled = .T. &lcCol..Enabled = .T. &lcCol..ReadOnly = .F. &lcCol..Sparse = .F. THISFORM.myGrid.Column5.DynamicCurrentControl = "IIF cDataForGrid.Editable, 'Chk1', 'Text1')" && THISFORM.MyGrid.Column5.CurrentControl = 'Chk1' also fails to accept input The checkbox shows up fine, displays the data fine. I can enter "T" or "F" in the textbox rows, so I don't think it's a column setting. What's weird is if I remove the textbox that's in the grid by default and ADDOBJECT a textbox, that textbox refuses to accept input as well. Anybody have any ideas? Tag: empty date insert into table Tag: 188758
  - 11
    - ODBC Trace not creating log file Hi Everyone, I'm using "MDAC 2.7 SP1 ON WINDOWS XP SP1" according to the component checker found at http://support.microsoft.com/default.aspx?scid=kb;[LN];307255 When I start an ODBC Trace from the ODBC Data Source Administrator, no log file is ever created. I've done two tests, one with a DSN using the Visual FoxPro ODBC driver (pointing to VFP tables on our Netware server), and one with the IBM INFORMIX 3.82 32 BIT driver (pointing to tables on a Unix box). I've downloaded tables with both DSN's to an excel spreadsheet, but no log file is created. I saw other posts on Google noting that the logfile is not always created where the path indicates, so I did a filesearch and there is no logfile on any of my drives. I've also checked the HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.ini\ODBC registry key and the values look right (Trace = 1 (when supposedly tracing, 0 when not), TraceDll = c:\windows\system32\odbctrac.dll, TraceFile = c:\odbc.log). Any suggestions? -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ quote of the day - "It's not cynicism if you're right" Tag: empty date insert into table Tag: 188755
  - 12
    - Error SD4.DLL Printer HP 1005 I would like to know if anyone has experience error when trying to print in a HP 1005 The system was developed in VFP 6.0 SP5 I print two reports, the first one it is print ok, but when I want to print the second one, I got the following error Program (the exe file) page no valid in module SD4.dll 0001:000003d Registry..... I tried many times to uninstall and re-install new drives but I always get the same error The system is running under W98 2nd edition Any help will be welcome Thanks in advance Mariano Tag: empty date insert into table Tag: 188753
  - 13
    - Sending a page break to a text file I am exporting data to a .txt file, and I need to specify to this text file when there is a page break. Is there an easy way to do this? Thanks!! Tag: empty date insert into table Tag: 188746
  - 14
    - Companies Using Foxpro. We need to show to our customers a list of companies that are using foxpro; so they will gain more confidence in our products. Tag: empty date insert into table Tag: 188742
  - 15
    - Proper case Is there a function to format strings in proper case? if not I will just write one thanks Tag: empty date insert into table Tag: 188739
  - 16
    - FPW2.6 incorrect order with SELECT ... ORDER BY 1 Hello, does anyone have any insight on this? I have an order system with an array of all the suppliers in a popup. This is the command I use to populate the array: SELECT supname,supref,supcurr,discount ; FROM supplier ; INTO ARRAY suparray ; ORDER BY 1 Recently the order has been rather random [after working OK for several years] and I naturally thought "index error.." Except it isn't, setting the order in the index sorts records correctly and deleting/recreating the index doesn't fix the problem either. If I replace the ORDER BY clause like so SELECT supname,supref,supcurr,discount ; FROM supplier ; INTO ARRAY suparray ; ORDER BY supname then all is correct again. Also SELECT supname,supref,supcurr,discount ; FROM supplier ; INTO TABLE c:\delme ; ORDER BY 1 creates a cursor with records in the correct order. According to the help under SELECT-SQL...ORDER BY it states I can use "A numeric expression indicating the location of the column in the result table. (The leftmost column is number 1.)" Why is the array suddenly out of order? Is it linked to the fact that I recently indexed the table on a field "supref"? It seems to be selecting the records in supref order. -- TIA Andrew Howell Tag: empty date insert into table Tag: 188737
  - 17
    - News for January from VS Data Product Manager Ken Levy Hello, All! http://msdn.microsoft.com/vfoxpro/letters/ -- Eric den Doop www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8 Tag: empty date insert into table Tag: 188730
  - 18
    - Tooltip question This is a multi-part message in MIME format. ------=_NextPart_000_002A_01C3E072.B0903440 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there a way to force the tooltip to show up without having the user = to hover the mouse over the object? sp ------=_NextPart_000_002A_01C3E072.B0903440 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.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Is there a way to force the tooltip to = show up=20 without having the user to hover the mouse over the object?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML> ------=_NextPart_000_002A_01C3E072.B0903440-- Tag: empty date insert into table Tag: 188728
  - 19
    - Calling VFP code from an HTML page Hi all, I'm using a DBI control ctExplorer where I can display HTML pages, I want to build a page where the links execute VFP code. Is there a class or a sample to do this? -- Edhy Rijo Programming System Solutions www.progytech.com Bronx NY Tag: empty date insert into table Tag: 188724
  - 20
    - Outputting to a text file - Bold Hello I am outputting text from my VFP7 application to a simple .txt file. Is it possible to bold certain lines that I put in there? I want some to be bold, and some to be regular. It seems to me that it is not possible but I thought maybe someone could prove me wrong. Thanks!! Tag: empty date insert into table Tag: 188722
  - 21
    - default positions problem... (foxpro dialogs) Where are the settings for the window positions (toolbars, property box, command box) stored at? every time i place them where i want them, as soon as i run the form im working on and close that form they all go back to what seems to be a default position. I tried doing set as default in the options dialog box, but still same effect... once i edited the config.fwp file and it fixed the problem, but now when i do it, i cant seem to get it to work, i kinda forgot what i changed... i think there might be a stored user settting somewhere from a previous dev working on this app.. any help would be nice.. thanks! Tag: empty date insert into table Tag: 188714
  - 22
    - List to Array How do I send the contents of a list to an array or cursor? Tag: empty date insert into table Tag: 188702
  - 23
    - DTS PAckage (local) Hi. I have a VFP 8.0 program, and a exe-file from this program This exe-file is inserted into a SQL-Server DTS-Package (local Package). The exe-fil creates a VFP-table, import a txt file in this table, and rhen scan the table. This works fine when i manual start the DTS-package, but when I schedule the package, the DTS-package stops when it reach the scan-command. Any suggestion to how I can solve this problem? Regards Trond Tag: empty date insert into table Tag: 188695
  - 24
    - compareing records Is there anyway to take two rows and compare the entire rows against each other to see if they are the same or diffrent? I'm trying to compare diffrent copies of records against each other and catch diffrences in the records and say hey this record and that record are the same person but they have a diffrent age... does anyone know of a way to do this? thanks Tag: empty date insert into table Tag: 188693
  - 25
    - numeric overflow OR Create cursor Just for your info or maybe somebody can explain it ? I have an "old" table (dbf clipper table, probable also with a fpd2.6 table) from which I retrieve records. if I use this to create the cursor I have no problems : Select "OldDbf" &&clipper or fpd2.6 =AFIELDS(arralg,"olddbf") CREATE CURSOR "temprepalg" from ARRAY arralg do while .not. eof("olddbf") Scatter To arralg Insert Into "temprepalg" From Array arralg &&error? skip in "olddbf" enddo *If I use this Select... Where .F. to create the cursor I get an error : *Numeric overflow on the line : Insert Into ... Select * From "alg" Into Cursor "temprepalg" Where .F. Readwrite do while .not. eof("olddbf") Scatter To arralg Insert Into "temprepalg" From Array arralg &&error? skip in "olddbf" enddo christophe \|||/ (o o) ----ooO-(_)-Ooo------------- ¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º Tag: empty date insert into table Tag: 188691

Dear All,

I have a table field which type is date.
How can I insert an empty date to that table field by using insert ... into
sql statement? I don't want to set control source bound to that input field.
Many thanks.

Regards,
Wandy Tang

Top

Re: empty date insert into table by Fred

Fred
Mon Jan 26 22:24:42 CST 2004

To represent an empty date field in VFP, use {} as the value:

INSERT INTO yourtable (datefield) VALUES ({})

Fred
Microsoft Visual FoxPro MVP

"Wandy Tang" <anonymous@discussions.microsoft.com.invalid> wrote in message
news:egL0tyI5DHA.1672@TK2MSFTNGP12.phx.gbl...
> Dear All,
>
> I have a table field which type is date.
> How can I insert an empty date to that table field by using insert ...
into
> sql statement? I don't want to set control source bound to that input
field.
> Many thanks.
>
> Regards,
> Wandy Tang
>
>

Top

Re: empty date insert into table by Cindy

Cindy
Tue Jan 27 09:44:29 CST 2004

In news: egL0tyI5DHA.1672@TK2MSFTNGP12.phx.gbl,
Wandy Tang <anonymous@discussions.microsoft.com.invalid> wrote:
> How can I insert an empty date to that table field by using insert
> ... into sql statement?

Hi Wandy,

Fred pointed out that an empty date is written in text as {}. Sometime you
may need to write an empty datetime value - you can use {/:} .

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Top