| Thread | Last Post | Replies |
|
| update trigger | 29 May 2004 17:30 GMT | 3 |
Is there an example of a table update/insert trigger that will allow me to take two fields concat them and store them in a third During an insert I insert a record with these values Field domain equals company.co Field user equals jo
|
| how to remove/uninstall SQL server ? | 20 May 2004 23:06 GMT | 2 |
I try to use "control panel" remove program to remove the SQL server, but it fails. Even I restart my PC, i still find the enterprise manager and other sql utiltiy.
|
| DBC Stored Procedure | 18 May 2004 14:41 GMT | 4 |
I have stored procedure in DBC that returns an integer value. Can I call it with ADO somehow? I'm using VFP8, CursorAdapter connecting to DBC over ADO (OLE DB Provider for Visual FoxPro) Thx.
|
| INT | 16 May 2004 15:06 GMT | 3 |
Friends, I have some problem with the existing code nVal = 300.000 nVal1 = INT(nVal / 60)
|
| INT() | 13 May 2004 21:12 GMT | 6 |
Friends, This is the entire code. This program created a numeric value to HH:MM format time I am using VFP6 and Access database -- bof()
|
| Mouse Click | 13 May 2004 20:44 GMT | 1 |
Friends, How can I add "Right Click" event at run time? Purpose: I have a grid that changes recordsource quite often and need to have
|
| foxpro and visual net | 13 May 2004 14:43 GMT | 1 |
Hello al i'm trying to use visual net basic to use table foxpro 8 , table in a database and table with a unique index primary key . i use the last oledb i found i use the connection builder, the dataadapter builder when i make the dataadapter i receive always the same error update ...
|
| Uniqueness violated on a composite key | 11 May 2004 17:34 GMT | 5 |
The last of the following statements generates the error "Uniqueness of index ORDPROD is violated". I don't understand why since both the fields are in the primary key. Am I missing something? I'm using the MS Visual FoxPro ODBC driver v. 6.00.8167.00 CREATE TABLE `C ...
|
| APPEND FROM CSV | 07 May 2004 19:11 GMT | 2 |
When importing a .CSV file into my .DBF table I do not get the content of the CSV file in the right field. I am using VFP 7 with SP1 In my DBF there are 2 memo fields which are ignored. The content of the corresponding "field" in the CSV file is put in another field (one more to ...
|
| Help me, please!! | 06 May 2004 19:11 GMT | 3 |
This frame of code get sintax error. Which is the correct sintax ? SELECT Tipo__CF,; CodiceCF,;
|
| SQL to file | 06 May 2004 14:32 GMT | 3 |
I am priting the following SQL Select to a file SELECT field1, field2, field3 FROM mytable TO FILE myfile NOCONSOLE PLAIN The problem is it is leaving first two lines in "myfile.txt" and then writing the SQL Select results in the file.
|
| ?Use of a "view" database | 06 May 2004 10:04 GMT | 7 |
I work in MS Access, but have need to "see" data in a VFP table. I was pointed to a KB article that suggests that a new, empty VFP database can be created, and "views" created inside that db, as a way of getting around issues with indexes in the original VFP db. I don't need to ...
|
| NULL display | 05 May 2004 21:20 GMT | 1 |
Friends, I am selecting some data from Access to VFP6 using DSN. The data displays ".NULL." wherever the field is empty. Even empty date fields display .NULL. Is there is any way to avoid this display?
|
| Compact and Repair database | 03 May 2004 20:14 GMT | 3 |
Is there is any way to trigger "Compact and Repair database" of Access 2000 from VFP6? rgds Wilson
|
| Mysql + Remote view = problem | 01 May 2004 11:10 GMT | 1 |
Got a strange behaviour Starting the remote views designer in order to create a remote view on a mysql db through a connection, first I can see all the db tables but when i select one of them I got an error because the designer try to open the table
|