Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / FoxPro / SQL Queries / September 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
too much space in field...29 Sep 2005 11:46 GMT2
I have VFP6.0.
In table, which I made, I have some columns.
One of them is CHAR(100), and in field I have:
"Name    Surname             Street"
ERROR:  Missing file "g_retsdx.prg" 28 Sep 2005 02:51 GMT1
I have a .NET application that I'm using to query a VFP table and, after it
has been working, I am getting a "g_retsdx.prg" file does not exist error.
Is there someone who can explain this error to me and tell me how to fix it?
Thanks!
SCAN...ENDSCAN for an table in buffered mode23 Sep 2005 18:14 GMT1
TABLE: so_line
*art_code    art_amt
----------+------------
uren            5
SQL help needed22 Sep 2005 18:13 GMT2
I'm trying to extract some data from a table, and can't figure out the
proper SELECT statement to extract the data I need.  Hopefully this is
an obvious and easy fix for those of you with more experience than I
(not hard...)
Which way is the quickest?20 Sep 2005 11:41 GMT3
i have to insert records in a table from another table. What is the quickest
way while looping through the original file, the append / replace method or
the sql - insert method?
Thanks!
SQL Pass through15 Sep 2005 04:07 GMT5
Moved my app to use SQL Pass Through on Windows 2k LAN.  All is well except
one user gets a seemingly random "internal consistency error" as he
instantiates one of the forms.  MSDN search results in a page that recommends
to call Microsoft Support who is looking for a credit card ...
Help with a query14 Sep 2005 06:33 GMT5
Why does this work:
SQLEXEC(1,'select ticket.serial, ticket.ticketnum, main.builder, ;
from main;
inner join ticket;
Update first come date into another table13 Sep 2005 19:35 GMT1
Table: ROLHAND
*dos_id     rol_datum      note
--------+-------------+----------
1          01-10-04        111
query with max date13 Sep 2005 04:20 GMT2
Table: ROLHAND
dos_id     rol_datum      note
--------+-------------+----------
1          01-01-01        111
need to find out how to use UPPER() function in SQL09 Sep 2005 23:52 GMT6
I have a remote view on a Progress table (parts master) and a local
table with some parts.
If I make a local view joining these 2 then some records are left out
because although the partnumbers (keyfield) are identical, they are
replace09 Sep 2005 23:48 GMT2
MAXDATUM
rol_id       max_datum
-------+------------
1            01-01-03
problema con fechas09 Sep 2005 13:50 GMT8
buenas
tengo en sql server la siguiente tabla
ss_mssp con
año_afiliacion    char(4)
Slow SQL in VFP 9.003 Sep 2005 14:48 GMT6
I am in the process of migrating some of my applications from VFP 6.0 to
VFP 9.0. I am experiencing slow results from queries that contain
sub-queries.
The SQL below runs and selects 1500 records in 1/10 of a second in Ver
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.