-
- FoxPro SQL help for Date Formats.
by Robeen_S
- 11 Replies
- Last post
by CetinBasoz
- Hi,
I'm using this SQL in FoxPro:
Select field1, field2, field3, substr(DTOC(datetimefield_1),1,10), substr(DTOC(datetimefield_2),1,10) from mytable.dbf where field1 = "searchvalue"
It works.
But I would like to specify that I want the datefields to be displayed in mm/dd/yy format rather than use the substr() function to truncate the datetime at the end of the yyyy. It seems
-
- How to create a dBase III Table with a CDX index
by Sergio Aguilar
- 7 Replies
- Last post
by dni
- Hello, I'm trying to create a table of dbase with a cdx index, but when I create the index, the type of it is MDX, so I want to know if there is a way to create the dbase file with a cdx index in vb.net, tnx for your help
-
- Positioning Dbf file in form/List Box
by Gary Demi
- 4 Replies
- Last post
by Gary Demi
- I have a form with a listbox, setting listbox.rowtype=6 (fields) and listbox.rowsource=seqlc.anum,customer,date,type,picture,pictfile,pictdir (fields) from a single dbf The DBF has an index on anum. (SET ORDER TO TAG anum) anum is unique, but not consecutive. When I use the up & down arrows & page up/dn within the the list box it works fine. The list is displayed correctly ordered by anum.
-
- DBF to CSV conversion
by ram_mv
- 13 Replies
- Last post
by dni
- Hi, I am converting a dbf file into csv file using C#. My program is working fine for file having fewer columns in dbf file. If the dbf file has more than 255 columns, I am getting the error "FILENAME" is not a table. I am using Visual foxpro OLEDB friver. I downloaded drivers from http://www.microsoft.com/downloads/detai ls.aspx fa milyid=e1a 87d8f-2d58 -491f-a0fa -95a3289c5 fd4&
-
- Need help adding a new auto increment integer field to a table
by Rob2001
- 5 Replies
- Last post
by Aleniko
- Hi I have a table that I want to add a auto increment integer field. I go into the database designer, Right click on the table I want to add the field to then select modify. Then I insert a field and give it the name client_id set the type to Integer (autoinc) it defaults to a width of 4. Then I tell it to index it accending. This works but on all the existing
-
- Drop MS Outlook emails on a foxpro control and save it to a .msg ??
by LeoLems
- 3 Replies
- Last post
by dni
- Hi everyone,
I am hoping someone can help me with this one...
I am looking for a way to save a dropped MS Outlook email message to a .msg file
The drop will be on a visual foxpro control (doesn't matter wich one)
I just want the .msg file and nothing else.. But I want it in a drag & drop kind of style.
It is similair to a drop of a email message on the desktop (
-
- w how to store encrypted passwords ..
by ibbm
- 9 Replies
- Last post
by Mark OSVATH
- is there some kind of algorithm in fox that can store and encrypted password so that if anyone got a hold of the data they couldn't read the password.
Thanks in Advance
-
- replace image with own name
by NILKAMAL
- 14 Replies
- Last post
by NILKAMAL
- hello!
is any way replace my image with include reeno or any field data
like i take image from my webcame and it store in one folder after that i use replace command so it save path in my field but when i replace that time image name want to change
here is my code below
DO [C:\Program Files\EZTwain\VFP\EZTwain.prg] TWAIN_SelectImageSource(0) * Get list of devices into memory TW
-
- Please Select on ComboBox
by Ahsan Amin
- 10 Replies
- Last post
by CetinBasoz
- How to add 'Please Select' on top of the ComboBox that lists a table field. It's ContorlSource is set on form's Init event and other properties in property window.
-
- Include DB in .exe
by hangover
- 9 Replies
- Last post
by hangover
- Hi. If I include a database in my compiled application via the Project Manager, how do I then reference it and its tables Do I still need to open the database and tables or are they automatically opened
Thanks.
-
- Error Installing VFP VS_SETUP.MSI
by 12l
- 14 Replies
- Last post
by Anonym_123
- ReInstalling VFP9 en mi W2k3
Standard SP1 the error message:
"The windows installer:
z:\vs_setup.msi could not be opened.
Setup will not continue.
This is a default response to an error. If
you see this please save log files and RAID a bug."
What happend Thanks
-
- Thumbnail -Images
by MM ROy
- 10 Replies
- Last post
by MM ROy
- Sir,
I am using Visual FoxPro 6.0 version. I want to view (like thumbnail) all the images of a folder (.jpg, .gif, etc.) using with visual foxpro form. The number of images may be varying. I have no idea....Please help...
Roy MM
-
- Farewell
by AndyKr
- 10 Replies
- Last post
by Joe Morel - MSFT
- Recent events, and postings, in this and other forums have convinced me that I am no longer able to act as a moderator in this forum and have asked that my moderator's privileges be withdrawn.
I shall no longer participate in this forum and hope that whoever takes on the task will do a better job than I.
Later:
I have been asked to say where I can be found outside this fourm so yo
-
- How to Copy 2 worksheet from one excel sheet to to 2 Worksheet of another Excel Sheet
by aditya_050484
- 3 Replies
- Last post
by CetinBasoz
- var xlApp, xlWB, xlSheet,f2,fso,oBook,oSheet,oBook1,oSheet1,idTmr; xlApp = new ActiveXObject("Excel.Application"); fso = new ActiveXObject("Scripting.FileSystemObject"); if(fso.FileExists("c:\\Example.XLS")) { f2=fso.GetFile("c:\\Example.XLS"); f2.Delete(); } xlApp.Visible = true; xlApp.DisplayAlerts=false xlWB = xlApp.Workbooks.Add(); xlWB.Sh
-
- Request to Refrain from Linking to UT Threads
by AndyKr
- 14 Replies
- Last post
by AndyKr
- I have removed the posts on this topic, and combined them, into a single, separate thread to avoid cluttering up a genuine quesion:
Naomi
Since you have withheld your E-Mail address I must post this caution publicly.
Please do NOT refer to "for-profit" sites - like the Universal Thread - in replies on this forum.
The reason is that the Universal Thread is not
-
- My exe does not running other PC
by mezofi
- 14 Replies
- Last post
by mezofi
- Hi! I built a project and I have a big problem. It is run only my PC, and if I put it on a pendrive (exe). But if I put it on an other PC , this program show only main page. Then when I click someone button, the program show an error message: Command contains unrecognized phrase/keyword (Error 36) It is very strange, because if it is on my pendrive the program good have not got any error. Mez fi f
-
- Unknown Classes Loaded in Memory
by Terry Montgomery
- 2 Replies
- Last post
by AndyKr
- I just realized a problem that we have been having and now I finally found out why. Now I need a solution to address it.
The gist of the problem is that we have a Public class based on another user defined class. When we compile the project, the class definition gets left in memory. As a result we cannot delete the files (clean the build folder) without closing out of the foxpro session. If I j
-
- Setting a date in VP 6
by ibbm
- 4 Replies
- Last post
by ibbm
- I want to set a date field to zeros
I use to use "replace datefield" with {"00/00/00"} but vp 6 doesn't like it.
Any help would be appreciated. Thanks
-
- Convert to original source code
by Bit
- 2 Replies
- Last post
by dni
- Hi,
Is there a way to convert an exe dbase IV program back to the original source code or .prg form to study
Afterwards, it will be rewritten in foxpro format.
Regards,
BIT
-
- SQL Select using variables
by cdaviduik
- 5 Replies
- Last post
by cdaviduik
- I would like to create a SQL SELECT statement in VFP9 but instead of specifying the table explicitly I would like it to be read from a variable. For example: TABLE_NAME = "table_to_select" SELECT * FROM TABLE_NAME; INTO CURSOR tbl_cur and when I execute the above I would actually like this to happen: SELECT * FROM table_to_select INTO CURSOR tbl_cur Any ideas on how to do this I have not
-
- Passing values to a form
by jan_sc
- 3 Replies
- Last post
by MarciaAkins
- hi all,
how can i pass values from textboxes lets say in form2 to form1 and then close form1 once i thisform.release form2, the values resetted.
thanks in advance.
regards.
-
- Problem when updating!!!! Help!!!
by pamtru
- 10 Replies
- Last post
by Naomi Nosonovsky
- Hi i have a problem when running this query in shared mode or set exclu off.
update table set field=5
It is very slow in a network or mapped drive. The crazy thing is that if the mapped drive is to a directory in the local computer it is very slow too. Example
use c:\table shared
update table set field=5
this go allright but now let suppose that i shared the fold
-
- help needed on troubleshooting label printer problem
by jimcjr
- 9 Replies
- Last post
by Naomi Nosonovsky
- I've inherited a Visual Fox Pro application (originally written in Foxpro for Windows, but more recently compiled with VFP 7 and then VFP 9). It creates several different types of labels using the standard .LBX and .LBT files that the Foxpro label designer creates. (All of the users are running the application on Win XP SP2 machines.)
The labels were designed using a Smart Label Printer Pro
-
- Form Display Problems
by MiamiFoxpro
- 2 Replies
- Last post
by MiamiFoxpro
- I am having some problems that are similiar to the VIsta Aero problem where a border style is causing parts of a form to be transparent. I have a form with a pageframe on it but the pageframe does not go to the top of the form. There are some buttons between the the top of the pageframe and the form. When the application is started the form background above the pageframe is transparent. It is not
-
- dates in vfp
by jmom
- 6 Replies
- Last post
by CetinBasoz
- Hello, my question is this: Is there a function to turn a datetime character into just a date character If not, I can figure out a way to work with using the DTOT() to convert my date expression into datetime format. Thanks for any future help.