Viewing 15 posts - 2,101 through 2,115 (of 2,452 total)
Agree about Welsh's comments on DLOOKUP......
have you tried "Refresh" or "Requery"....either on the textbox or the parent form?...after your code
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 2, 2012 at 9:55 am
What version of Progress ?
Have you got the relevant Progress ODBC driver for your version?
Are you just looking at extracting the data from Progress...or sometning else?
How many tables/size/rowcounts etc.
Generally speaking,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 2, 2012 at 5:41 am
Plus 1....and forgive me for adding one word.....
Healthy
and
Prosperous New Year!!!
🙂[/quote]
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 31, 2011 at 12:13 pm
here is an example using 'FOR XML PATH'
-- create some data
with produce (id,fruit, varieties)
as (
SELECT 101,'Apple', '3' UNION ALL
SELECT 101,'Banana', '2' UNION ALL
SELECT 102,'Orange', '1' UNION ALL
SELECT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 18, 2011 at 2:06 am
frdrckmitchell7 (11/28/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 28, 2011 at 1:21 pm
....looking at whatt has been provided by the OP, I have a suspicion that the requirement is to maybe concatenate rows based on
RN 1 + RN 5 + RN 9....
RN...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 28, 2011 at 10:57 am
Lynn Pettis (11/23/2011)
J Livingston SQL (11/23/2011)
does this help you....
SELECT Contract, Client, COUNT(*) AS ContractCountFROM tbl_temp
GROUP BY Contract, Client
HAVING (COUNT(*) > 1)
Actually, I think this is what is needed:
select Contract,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 23, 2011 at 4:18 pm
does this help you....
SELECT Contract, Client, COUNT(*) AS ContractCount
FROM tbl_temp
GROUP BY Contract, Client
HAVING (COUNT(*) > 1)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 23, 2011 at 3:32 pm
Hi
I am trying to understand the business logic that allows you to have a single contract number with two versions that appear to be assigned to different Clients.....??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 23, 2011 at 2:53 pm
krypto69 (11/22/2011)
Long story but we are using a query to populate a table then doing a data dump from...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 22, 2011 at 2:24 pm
Tara-1044200 (11/18/2011)
.....when i check the definition of the new table by doing "script as create" i see alter stmts in the definition ......
Please confirm how you are perfoming "script as...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2011 at 1:24 pm
Ninja's_RGR'us (11/18/2011)
Then you can either join to it or prepopulate the variables using that id to navigate...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2011 at 9:55 am
will you only ever have 4 columns?
what happens when you have more than 4 rows?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2011 at 3:44 am
anthony.green (11/17/2011)
please post the DDL and sample data of the objects in the problem
Charmer...pls post as asked above
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2011 at 2:17 am
based on what you posted...what results do you expect.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2011 at 1:49 am
Viewing 15 posts - 2,101 through 2,115 (of 2,452 total)