Click here to Skip to main content
15,881,380 members
Home / Discussions / Database
   

Database

 
AnswerRe: return Table name + Column Name in sql query Pin
MBCDC21-Jul-08 0:39
MBCDC21-Jul-08 0:39 
Questiondynamically applyin styles based on DB Value to reports Pin
ch.ramesh16-Jul-08 19:06
ch.ramesh16-Jul-08 19:06 
AnswerRe: dynamically applyin styles based on DB Value to reports Pin
Ashfield16-Jul-08 20:13
Ashfield16-Jul-08 20:13 
GeneralRe: dynamically applyin styles based on DB Value to reports Pin
ch.ramesh16-Jul-08 20:21
ch.ramesh16-Jul-08 20:21 
GeneralRe: dynamically applyin styles based on DB Value to reports Pin
Ashfield17-Jul-08 2:24
Ashfield17-Jul-08 2:24 
QuestionMultiple queries within an ADO connection Pin
Airickjay16-Jul-08 9:50
Airickjay16-Jul-08 9:50 
AnswerRe: Multiple queries within an ADO connection Pin
tsaunders16-Jul-08 15:09
tsaunders16-Jul-08 15:09 
AnswerRe: Multiple queries within an ADO connection Pin
andyharman17-Jul-08 7:15
professionalandyharman17-Jul-08 7:15 
I would say that the following line looks iffy:
strLseQry = "SELECT L_NAME, F_NAME1, F_NAME2,  ADD_INFO FROM LEASES WHERE LEASE_ID = '"&aLeaseList&"'"

If LeaseNum values are numbers then your aLeaseList should be comma-separated, then use:
strLseQry = "SELECT L_NAME, F_NAME1, F_NAME2, ADD_INFO FROM LEASES WHERE LEASE_ID IN ("&aLeaseList&")"

If that doesn't work then post the value of your strLseQry variable to this thread.
AnswerRe: Multiple queries within an ADO connection Pin
Airickjay17-Jul-08 8:30
Airickjay17-Jul-08 8:30 
AnswerRe: Multiple queries within an ADO connection Pin
MBCDC21-Jul-08 0:59
MBCDC21-Jul-08 0:59 
Questionerror when deleting with the WITH clause? Pin
harcaype16-Jul-08 7:01
harcaype16-Jul-08 7:01 
AnswerRe: error when deleting with the WITH clause? Pin
tsaunders16-Jul-08 15:02
tsaunders16-Jul-08 15:02 
GeneralRe: error when deleting with the WITH clause? Pin
harcaype16-Jul-08 19:13
harcaype16-Jul-08 19:13 
AnswerRe: error when deleting with the WITH clause? Pin
leoinfo17-Jul-08 4:19
leoinfo17-Jul-08 4:19 
GeneralRe: error when deleting with the WITH clause? Pin
harcaype17-Jul-08 5:56
harcaype17-Jul-08 5:56 
QuestionHow to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 1:51
fracalifa16-Jul-08 1:51 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 2:18
A Wong16-Jul-08 2:18 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 3:01
fracalifa16-Jul-08 3:01 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 3:15
A Wong16-Jul-08 3:15 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 3:32
fracalifa16-Jul-08 3:32 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 3:41
A Wong16-Jul-08 3:41 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 4:10
fracalifa16-Jul-08 4:10 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 4:38
A Wong16-Jul-08 4:38 
GeneralRe: How to get the first rows of a relational table (depending of the last date of change) Pin
A Wong16-Jul-08 4:50
A Wong16-Jul-08 4:50 
AnswerRe: How to get the first rows of a relational table (depending of the last date of change) Pin
leoinfo16-Jul-08 4:29
leoinfo16-Jul-08 4:29 

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.