Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dgrewe
  • Content: Threads
  • Order by date
  1. dgrewe

    Record locking a VFP table from C#.NET

    I know this is more of a C#.NET question, but I'm a VFP programmer just learning C# and can not find the answer to this question anywhere. In C#.NET I have to access a VFP table (SYSKEY.DBF) in a VFP database using 2 fields (dbfname c(10), keyfield c(10)). The table has No Primary Index or No...
  2. dgrewe

    VFP9 ODBC connection errors (again)

    Just got an Application written VFP3 and they want many changes and it updated to VFP9. There are 2 database. The main VFP database with all the tables is on the Server. A second VFP database, holding nothing but views and connection string, is on the local computer running the application...
  3. dgrewe

    Display a calculated field in a grid

    I have never had to do this before, Client wants an Asterick to appear in a column in a grid if the duedate is greater then todays date. There is no filed in the table for it so it is on-the-fly for each record in the grid. Where do you place it in the grid? I assume it is someplace in the...
  4. dgrewe

    Database Table, Column & Index Info

    I have to create a Database clone application (in VFP) to copy a database from one MSSQL/Oracle server and keep it mirrored to another MSSQL/Oracle server, (Yes I know there is a built-in Oracle / Mssql application) but do to the costs and licensing fees the clients of this application want me...
  5. dgrewe

    Insert Trigger Question

    I know just this side of nothing about MSSQL triggers, (I'm a VFP programmer) but I have to write a trigger for a client. Some rogue program is placing a record in a table (SYINVL) with a primary key of zero. Then days later the application crashes when a second person attenpts to add a...
  6. dgrewe

    SQL Statement Not working the way I want it to

    I have a MSSQL statement called from VFP that is Kicking my rear to find the problem. Any help would be welcomed. I'm not a MSSQL fan. The Resulting table is suppose to return all the other inmates in a Jail facility that had potential contact with other inmates. This does not involve a...
  7. dgrewe

    PrimaryKey Problem

    OK what am I doing wrong ? The question is, Why am I getting the Fox error "The uniqueness of Primary Key Violated" from what I have done below ?? Trying to create a database to document the classes of a Very Large application. I created 3 tables LIBRARIES - 21 unique records for the...
  8. dgrewe

    .NULL in fields after SELECT Full Outer Join

    For the first time I've have to use the full outer join command and the results of the fields have ".NULL" in them. Any way to remove the ".NULL" ? SELECT Projects.*, Newgpo.* ; FROM projects FULL OUTER JOIN newgpo ; ON Projects.project = Newgpo.project; ORDER BY...
  9. dgrewe

    ODBC, VBasic Script -> VFoxPro with SQL question

    I do not know anything about VBasic Script and the programmer that did left the company and the company want me to make a change to the asp file. A ".asp" Form has 5 fields. File looks for data in any one of the fields and does a SQL on the first field if finds info in. Company...
  10. dgrewe

    ODBC -> VFP Table & SQL problem

    I do not know anything about VBasic Script and the programmer that did left the company and the company want me to make a change to the asp file. A Form has 5 fields. File looks for data in any one of the fields and does a SQL on the first field if finds info in. Company now wants a 2 field...
  11. dgrewe

    Print from NT to Win2k

    Several customers with Win2k computer are asking if we can print directly to their printers. We already deliver the information by Fax, Overnight Mail, Email, FTP and by a Secure Internet Server Web Page unique for each customer. Plus the customers can have any combination of the delivery...
  12. dgrewe

    Win98 internet print to Win2K.

    Anyone Know where I can go to get infomation on how to: Print from Win98 Computer connected to internet to a Win2K computer connected to internet. The computers are on different local area network in different domains in different companies not associated with each other. One is a Customer of...

Part and Inventory Search

Back
Top