Pass a variable to a linked server (FoxPro) query

I'm having problem with an OpenQuery statement in stored procedure, which should be run on FoxPro linked server. I'm getting either an error messages or not the result I expected. I know that the problem is with WHERE part, without this part it works.Here is the code:-------------------------------- ...

Oracle to Foxpro Query

i m using this query in Oracleselect * from xyz where rowid in(select max(rowid) from xyz group by party)i want to use this query in Visual Foxpro. but ROWID is not working in VFP.please give me alternate to rowid to use in VFP ...

Oracle to Foxpro Query

i m using this query in Oracleselect * from xyz where rowid in(select max(rowid) from xyz group by party)i want to use this query in Visual Foxpro. but ROWID is not working in VFP.please give me alternate to rowid to use in VFP ...

FoxPro query length limit

I have 2 tables (in different DBs: Access2000 and FoxPro 6) holding Employee's data. I need to extract all the records records from 1 table which DO NOT exisy in the other.I've tried using something like this:SELECT E.Data FROM tblEmployee E WHERE E.EMPLOYEE NOT IN ("%0", "%12452 ...

Why is the number of records returned different?

FoxPro frontend Sequel Server backendProblem: When I run a Crystal Report, the number of records returned is different from the FoxPro query when I use the same query parameters. Any suggestions as to why the difference? ...

Single SQL Query to two Foxpro (ODBC) connections

I like to know if anyone of you out there can help me solve this issue. I need to generate an SQL Query to access two different FOXPro (databases) connections.Example,Connection 1 - has a DSN setup of CMSBM and it sits in the path of D:/CMS/CMSBM/= and the table is bmboml15Connection 2 - has a DSN s ...

query data from the linked foxpro database

my question is :how do I query data from the linked foxpro database?more:I have linked a visual foxpro server to my sql server database by using the addserver clause.Two server is in a local network.My linked foxpro server named 'fox'.its datasourse is not a dbc file, but a directory of dbf files ,a ...

How to Get MonthName in Excel Query

I am using a date field in Microsoft Query in Excel 2003.I want the query to return MonthName instead of date. the Query is: Select MonthName(Order_Date) as Date from ORDERS. Ihave also tried CMonth Function but I am not able to returnonly the MonthName from date value. Function Month() works but it ...

The query time of the records from a foxpro Database is unusually high

Issue:The query time of the records from a foxpro Database is unusually highover a LAN of 10mbps.Description:1. I have a foxpro Db on a machine with 100000 records. I have several clients trying to access this database over a LAN of 10mbps.2. The fields in the foxpro database are indexed3. When i tr ...

The query time of the records from a foxpro Database is unusually high

Issue:The query time of the records from a foxpro Database is unusually highover a LAN of 10mbps.Description:1. I have a foxpro Db on a machine with 100000 records. I have several clients trying to access this database over a LAN of 10mbps.2. The fields in the foxpro database are indexed3. When i tr ...

foxpro 206/access based query to get subtoal and totals of groups

D/friendsi need a query (foxpro 26 based or access based) to get subtotal and total s of row.. e.gitem field1 field2 field3aaasubtotal subtotal subtotalbbbsubtotal subtotal subtotaltotal total total ...

getting query engine error,crystal reports,vb.net,foxpro

iam working on an orderprocessing application.i wrote the following codeDim empReport As New PackSlip()Dim cnn As New OdbcConnection()Dim empAdapter As OdbcDataAdapterDim empDS As DataSetDim strQryString As StringDim strQryString1 As StringstrQryString = "Select Orders.order_num,Orders.status,O ...

JOIN & Query Problem - unique indexes & PKs, converting FoxPro to MySQL

Our company has live data in a FoxPro 9 source database whose structure and functions cannot be edited - it is part of an application we purchased 15 years ago that will soon no longer be supported. I am using DB Sync to synchronize tables from the FoxPro DBCs (Windows XP) to MySQL 5.0.92 (Mac Snow ...

VB.NET 2005 query FoxPro 9 - Need Help

I'm a VB neophyte, and I am attempting to connect to a FoxPro 9 .DBF file and run queries against it. I have searched for two days trying to find some solid examples with code on how to accomplish this. I can say I found an incredible tutorial on how to connect and run queries against a MySQL databa ...

FoxPRO and PHP... SSL query?

Anyone managed to utilise a foxpro db connection and data manipulation through foxpro? Assuming Said connection is possible any steps need to be taken to utilise SSL connection?Im not the worlds most expert php guy out there so some help would be nice...email : z.star@gmx.net ...

Convert a query into a table foxpro

I am new programmer in Delphi. I would like to ask how I convert a query into table foxro. For example procedure TForm1.Button3Click(Sender: TObject);var filetable:ttable;nomor:integer;beginQUERY2.Close;QUERY2.SQL.Clear;QUERY2.SQL.Add('SELECT status_k,tglkirim,status_r,penerima,kdpenerima,kode_r FRO ...

Undefined function 'MonthName' in expression in c# stored query

HiI have a c# console app that calls some access 2007 queries. One of these queries throws an error "Undefined function 'MonthName' in expression". I understand that some functions that are available in VBA cant be called from c# and if i comment out the 'monthname' function the call works ...

Visual FoxPro Update Query

Please help!I want to run an update query to match the service price (serprice) of a specified service code ("1") from another ("2") in the same table.Here is a sample that doesn't work.UPDATE t1 ;SET t1.serprice = t2.serprice ;FROM sertable t1 ;JOIN sertable t2 ;ON t1.customer = ...

MSAccess query. Extract distinct monthName

Need to extract distict monthNames from date column.This------SELECT DISTINCT (Format(appointmentdate,'mmmm')) AS distinctmonth ------does not work. Please advise. ...

MySQL Explaination/Query Help Request

I'm trying to figure out why I am getting some duplication with the following query: ELECT DISTINCT MONTHNAME(T.Created) as 'Month', SUM(IF(ocfvSev.Content = 'One', 1,0)) as 'One', SUM(IF(ocfvSev.Content = 'Two', 1,0)) as 'Two', SUM(IF(ocfvSev.Content = 'Three', 1,0)) as 'Three', SUM(IF(ocfvSev.Cont ...

Problem connecting to Foxpro

I use sp_addlinkedserver create a link to Foxpro files by using the lastest VFPOLEDB driver. If I use QA to query the table, it works fine. But if I put that query into scheduled job in SQL Server Agent, I get this error message:Executed as user: domainName\domainAccount. Could not initialize data s ...

ms access query help

I was wondering if anyone can help with this query. It doesn't seem to be that hard but I am having trouble with it. Any help would be greatly appreciated!I have a simple select query that selects records from 2 tables based on 2 criteria.SELECT Main.PHNQ, TeleScrp.XPriorityFROM Main INNER JOIN Tele ...

Union query discrepancy

When I run the following query with a UNION:SELECT dbo.TBLCCINFORMATIONOCTOBER04.NAME, dbo.TBLCCINFORMATIONOCTOBER04.TITLE, LOWFARE, ITPSG.TBLCCONLINETOOL.AMOUNT as PRICE, 15 AS Lostsavings, LEFT(dbo.TBLCCINFORMATIONOCTOBER04.CostCtr, 4) AS COMPANYCODE, ITPSG.TBLCCONLINETOOL.InYear, ITPSG.TBLCCONLIN ...

Linked Server to Visual FoxPro Not Work

I've downloaded and installed the latest VFPOLEDB (12/04) on 2 separate SQL Server boxes.In both cases, If I connect to SQL Server with Query Analyzer as (local) while on a box, the linked server to my foxpro database works fine with openquery().However, If I'm at one box and attached to SQL Server ...

transdt greater than same month of cycdt (was "Complex query")

I am having trouble in getting the expected results. I have two tables as below. I need Idno,transdt,cycdt,amt from joining two tables. The criteria is that if the transdt greater than same month of cycdt then we need get the next month cycdt and corresponding amount for that, if it is less than or ...

query is wrong?

This is related to php too:$sqlQuery = "Select *, MONTHNAME('dateSigned') as month from guestbook ORDER BY name";$result = mysql_query($sqlQuery, $db) or die("Unable to query database.");while($myrow = mysql_fetch_array($result)) {$dateSigned = $myrow["month"];printf( ...

FoxPro to MySQL conversion

I have several data tables that I have to export from Visual FoxPro to MySQL. I'm using MS SQL to import the tables from FoxPro, then export to MySQL. I've not encountered any problems, except for one FoxPro table that has columns with datatype "memo" and so the table has several files: .d ...

Query Speed

SUMMARY:Here are the issues I need resolved:(a) how can I stop one query from putting a hold on all other simultaneous queries?(b) Will switching from a MyISAM db to another storage engine improve general performance, given that I don't need locking?(c) Can the code below be simplified?MySQL version ...

Have a query but need the sum of a sum

I have this query so far:SELECT SUM(t1.totalprice) as totalprice,SUM(t1.sales) as sales, t1.`year` as `year`,t1.mnth as `month`from (SELECTSum(crm_sales.totalprice) AS totalprice,MONTHNAME(crm_sales.date) AS mnth,YEAR(crm_sales.date) AS `year`,Count(crm_sales.totalprice) AS sales,MONTH(crm_sales.dat ...

can u plz help me my query behave like this

when i run the query for current month it succefull. again run the query for last month it specifythat single row subquery can't contain one or more rows i was succeful i was omit the emp_number 11780. SELECT EMPLOYEE_DIM.EMP_KEY,EMPLOYEE_DIM.EMP_NUMBER, EMPLOYEE_DIM.EMP_FIRST_NAME || EMPLOYEE_DIM.E ...

MySQL Trouble with count() and group by in my query

here is my query select count(*) as id2,monthname(sa.schoolabs_date) as bulan from SA sa,YL yl where sa.national_id='xxx' and sa.note='yyy' and yl.y_level='rrrr' and yl.y_id=sa.y_id group by monthname(sa.schoolabs_date) order by sa.schoolabs_date asc there my query doesn't have result what i wanted ...

Retrieve Data on Remote FoxPro DB from Linux PHP

We are developing a website in PHP and we need to retrieve just a few records from a FoxPro Database that is used by a software program called Fabritrak, made by a company called Metalsoft. I have spent many hours trying to find a solution for this and ran across something called ODBC Socket Server ...

ADO Connection to FOXPRO Database

Issue:The query time of the records in a foxpro Database is unusually highover a LAN of 10mbps.Description:1. I have a foxpro Db on a machine with 100000 records. I have several clients trying to access this database over a LAN of 10mbps.2. The fields in the foxpro database are indexed3. When i try ...

Foxpro 9.0 and MySQL ODBC

We made an small application using Foxpro 8. The problem we found was that Foxpro reads ever darn record in a table instead of simply passing on a SQL query to MySQL. I was told Foxpro 9 would resolve this. We're running it on XP with SP2. The ODBC connector 3.51 and 5.0.0 (alpha) both appear to be ...

Writing data to a FoxPro Memo Field with ASP form

Help is greatly appreciated. Many Karma points will be awarded.I have an ASP form that inputs data into a FoxPro free table (dbf). The "details" field is a memo field where the user should be able to enter unlimited data. The form works great, except:1.) when there is a line break (enter) ...

Query cannot be updated

HaiI am using vb as front end and visual foxpro as back end for myapplication. I am reading some data in excel and checking some fields withmy database and if match found i am updating the fields from excel to mydatabase. I am using find method for matching and after the record get matched i try to ...

Delphi & Foxpro database

Need help trying to figure out why I cannot use a query (TQuery) in which I'm querying two databases. I get the error: "Operation could not be completed. File or directory does not exist. C:\App\PDOXUSRS.LCK C:\App\PARADOX.LCK'No DatabaseName is specified in the Tquery property because it's usi ...

Multi-page query output

PHP newbie so please be gentle :) The following script retrieves data and displays the results from a Visual Foxpro table<html><head><title>Untitled Document</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head> ...

ODBC Query over WAN using VB

Ok here is some background. We have a remote office, connected to a DSL connection. We use a VPN to connect the remote office to our office to form a WAN. We have also got a visual foxpro database in the main office which we wish to connect with using ODBC.This application queries the database and r ...

Query cannot be updated because from clause is not a single simple table name

HaiI am using vb as front end and visual foxpro as back end for myapplication. I am reading some data in excel and checking some fields withmy database and if match found i am updating the fields from excel to mydatabase. I am using find method for matching and after the record get matched i try to ...

Any way to Link to Foxpro in read/write mode?

I used to have a real handy Access application that could write/update fields in a Foxpro DB. Now with Access 2002 we have to use ODBC to link, and it's read only (as far as I can tell). Is there any way to link to a Foxpro DB table, and be able to link to it with all the same write functions as a n ...

How do I link FoxPro 2.6 Tables to my Access 2000 Database?

How do I link FoxPro 2.6 Tables to my Access 2000 Database?Used ODBC.Some FoxPro Tables (.DBF) open up fine and others do not.Ones that do not open, I get the following error message:"Could not execute query; could not find linked table.[Microsoft][ODBC Visual FoxPro Driver]File 'Blah' does not ...

Linked FoxPro Table and ODBC errors...

I built a form(AddNewItem-Correct) on a query(AddNewItem) that contains a couple Access tables and an entire linked FoxPro table. The form is to add records to the foxpro(inventry) table bassed on information in the access tables. I have a control that builds a query string in VBA and then uses the ...

Visual Foxpro or MS Access

for my work i need pro-arguments to use Visual Foxpro and not MS Access? What's the best program to work with big data tables (800.000 rec.)? I just use Visual Foxpro to query and replace records in a big table (it's an alternative for Microsoft Excel because Excel has a limit of 65.536 rec.). Thank ...

Using Access to sum FoxPro get inconsistent totals

The environment:FoxPro tables linked into an Access 2000 (or 2003) database using Microsoft VFP ODBC driver 6.0.something.Ran a simple select query on a single table. Group by a date field and sum the total paid column to get a total by month.The Problem:Ran the exact same query multiple times one i ...

Trying to query a season in mySQL

I'm trying to define queries which show different chunks of output depending on whether it is Spring, Summer, Winter or Fall. Right now I have 4 queries similar to the following:$query = "SELECT monthname(e_DateStart) as eMonth, dayofweek(e_DateStart) as eDay, e_DateTitle, subeTitle, subeDescFR ...

Linking to Visual Foxpro from MS Access

All. I have an MS Access database that links to a visual foxpro (VFP) database that uses free tables (not a database container) using the MS ODBC driver. The VFP tables are now in VFP 8 which cannot be reliably accessed using the old MS ODBC driver. I have tried to create a pass-through query, but i ...

how to select foxpro Date thru php ?

i have a foxpro DB, i using ODBC to connect it.I face a problem now, that is $date = "2003-09-26" ;$query = "SELECT id,name,resign FROM employee WHERE resignDate = '$date' "$result = odbc_exec($pr, $query); i can't select out any result. b'cos the format $date incorrect to the fo ...

Date Issues in Access XP query

I am trying to create a query to append info from one table to another. I need it to create a Month field (where the Month Name is the current month) and a Due date field (where the due date is the 15th of the next month unless it falls on a friday or saturday) I was using Month: MonthName(Month(Dat ...

Linking to Foxpro - edit in datasheet view?

HiI'm trying to link and edit some FoxPro tables.I achieve the linking fine, but the tables always end up read-only in datasheet view.This is my first time working with ODBC files. Any advice to enable editing within Access's datasheet view please? Is it possible ?I've worked through many posts here ...