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 / October 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Connecting to FTP30 Oct 2006 11:16 GMT1
I need to copy a file to an ftp site from VFP. How do I do it?
Assume ftp site and folder is:  ftp.zzz.com/input
Assume username is ABCDE
and password is 12345
ERROR: Accessing VFP data from Query Analyzer23 Oct 2006 19:07 GMT1
Please help,
I can't for the life of me figure out why i get this error when executing
the following statement.  I have installed the latest OleDb drivers.......
Any help will be greatly appreciated.
QUERY STATES 24 RECORDS FOUND BUT NONE ARE SHOWN?19 Oct 2006 16:35 GMT12
I ran a query today on a DBF file in VFP9.0 where it stated it retrieved 24
records BUT it displayed none. Another query said it retrieved 11 records but
only displayed 8.
Where might the missing records be? Or what has actually happened?
Updating one table with another18 Oct 2006 16:02 GMT4
I have two tables:
Master - has dozens of fields, approximately 10000 records
Corrections - Has five fields (item, serial, firstrent, origcost,
acquired), 500 or so records
query question - CASTing a text field to a date and comparing16 Oct 2006 20:03 GMT1
Hi, I'm writing a foxpro query and having trouble.
My original query:
Select * from PRSNPSHT
Where (snp_ckdate > {^2016-10-16} or snp_ckdate < {^1900-01-01})
Query with mutiple results - bot or top14 Oct 2006 14:09 GMT6
When exexuting a query in VFP8 and you have the posibility of having multiple
results in the output set is the result pointer setting at the bottom or top
of the set of records returned.
There is no "order by" clause in the query.
Count and display numbers of items in a result set13 Oct 2006 14:20 GMT2
        I currently run the following query against a database;
SELECT ahd.call_req.ref_num AS Incident
FROM ahd.call_req JOIN ahd.act_log
ON ahd.act_log.call_req_id=ahd.call_req.persid
Refresh View09 Oct 2006 02:43 GMT1
How to refresh the view in order to get the latest data?
NEED HELP WITH SYNTAX06 Oct 2006 10:53 GMT2
I have the following SQL INSERT query in which the VFP driver says I have a
syntax error - need help with finding where the error is. The VFP help does
not yield any help with this.
INSERT INTO PCOILS
 
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.