Click here to Skip to main content
16,005,181 members
Home / Discussions / Database
   

Database

 
GeneralRe: run time error Pin
williamchou14-Apr-04 16:56
williamchou14-Apr-04 16:56 
GeneralRe: run time error Pin
Mike Dimmick15-Apr-04 2:26
Mike Dimmick15-Apr-04 2:26 
GeneralProblems with Sandbox Mode Pin
blakeb_114-Apr-04 9:23
blakeb_114-Apr-04 9:23 
GeneralRe: Problems with Sandbox Mode Pin
monrobot1314-Apr-04 10:00
monrobot1314-Apr-04 10:00 
GeneralRe: Problems with Sandbox Mode Pin
Mike Dimmick15-Apr-04 2:28
Mike Dimmick15-Apr-04 2:28 
GeneralRe: Problems with Sandbox Mode Pin
Chris Meech16-Apr-04 9:26
Chris Meech16-Apr-04 9:26 
GeneralReporting Services Pin
Kant14-Apr-04 9:09
Kant14-Apr-04 9:09 
GeneralSELECT and UPDATE in one statement Pin
iluha14-Apr-04 4:39
iluha14-Apr-04 4:39 
Hi everyone
I'm working a program that needs to interface with a dBase 3 and pull records (sometimes limited amount) based on a zip code field.

Also i need to pull the oldest records first by using MAILED field.
I came up with this query to pull the data:

SELECT TOP 5 * INTO DESTINATON.dbf FROM SOURCE.dbf WHERE ZIP5 = '95003' ORDER BY MAILED ASC

This query works. It select top 5 record, creates DESTINATON.dbf witch is identical in structure to SOURCE.dbf and populates it with selected records.

The hard part is to update the MAILED field in the same query, so next time I don't use the same records.
There in no unique field that i can use to match pulled records to the SOURCE.dbf and update it.
I want to do it all in one shot, but I'm not sure that this is possible.

I'm using ADO 2.7

Any help is greatly appreciated.
Thank you
Ilya
Eek! | :eek:
GeneralRe: SELECT and UPDATE in one statement Pin
Janya26-Apr-04 14:44
Janya26-Apr-04 14:44 
GeneralProblem with table format when pulled from SQL Server to Sql Server CE, using RDA Pull Method Pin
JustChiLLin14-Apr-04 1:13
JustChiLLin14-Apr-04 1:13 
Generalthe problem of @@TRANCOUNT--how to eliminate the no.266 error Pin
williamchou13-Apr-04 23:33
williamchou13-Apr-04 23:33 
GeneralRe: the problem of @@TRANCOUNT--how to eliminate the no.266 error Pin
Mike Dimmick14-Apr-04 5:28
Mike Dimmick14-Apr-04 5:28 
GeneralSET DATEFORMAT Pin
monrobot1312-Apr-04 19:13
monrobot1312-Apr-04 19:13 
GeneralRe: SET DATEFORMAT Pin
Mike Dimmick13-Apr-04 4:05
Mike Dimmick13-Apr-04 4:05 
GeneralRe: SET DATEFORMAT Pin
monrobot1313-Apr-04 15:20
monrobot1313-Apr-04 15:20 
GeneralFormat Columns Pin
monrobot138-Apr-04 16:42
monrobot138-Apr-04 16:42 
GeneralRe: Format Columns Pin
Colin Angus Mackay9-Apr-04 0:12
Colin Angus Mackay9-Apr-04 0:12 
GeneralRe: Format Columns Pin
monrobot139-Apr-04 6:13
monrobot139-Apr-04 6:13 
GeneralMSDE Deployment Pin
betterc8-Apr-04 5:50
betterc8-Apr-04 5:50 
GeneralRe: MSDE Deployment Pin
Sarvesvara (BVKS) Dasa13-Apr-04 18:31
Sarvesvara (BVKS) Dasa13-Apr-04 18:31 
GeneralRe: MSDE Deployment Pin
betterc14-Apr-04 0:58
betterc14-Apr-04 0:58 
GeneralRe: MSDE Deployment Pin
Sarvesvara (BVKS) Dasa14-Apr-04 1:03
Sarvesvara (BVKS) Dasa14-Apr-04 1:03 
GeneralRe: MSDE Deployment Pin
betterc14-Apr-04 1:03
betterc14-Apr-04 1:03 
GeneralRe: MSDE Deployment Pin
Sarvesvara (BVKS) Dasa14-Apr-04 1:06
Sarvesvara (BVKS) Dasa14-Apr-04 1:06 
GeneralRe: MSDE Deployment Pin
betterc14-Apr-04 1:08
betterc14-Apr-04 1:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.