Re: [NF] Transact-SQL problem

On Tue, Jan 8, 2013 at 10:02 AM, Paul Newton wrote: > Hi all > > The following is a column definition (part of a create table statement in > Transact-SQL > > [wp_pssslip] [int] NOT NULL CONSTRAINT > [DF_wparm_wp_pssslip] DEFAULT (24) > > I want the default value for this field

RE: [NF] Transact-SQL problem

Thanks Paul - I will explore that ... -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul McNett Sent: 08 January 2013 16:09 To: profoxt...@leafe.com Subject: Re: [NF] Transact-SQL problem On 1/8/13 8:02 AM, Paul Newton wrote: > Hi all >

Re: [NF] Transact-SQL problem

On 1/8/13 8:02 AM, Paul Newton wrote: > Hi all > > The following is a column definition (part of a create table statement in > Transact-SQL > > [wp_pssslip] [int] NOT NULL CONSTRAINT > [DF_wparm_wp_pssslip] DEFAULT (24) > > I want the default value for this field to be the

[NF] Transact-SQL problem

Hi all The following is a column definition (part of a create table statement in Transact-SQL [wp_pssslip] [int] NOT NULL CONSTRAINT [DF_wparm_wp_pssslip] DEFAULT (24) I want the default value for this field to be the lesser of 24 and the value of another field (wp_summpp

RE: SQL Problem

Thanks for replying Bernardo, as you will see from my reply to Dave all is now well. John Weller 01380 723235 07976 393631 > > Does the problem occur if you use 0 (zero) instead of EMPTY in the IIF? > > ___ Post Messages to: ProFox@leafe.com Subscrip

RE: SQL Problem

Thanks Dave - that sorted it! I guessed it was something fairly straightforward that I just wasn't seeing!!! I'm badly out of practice these days at writing anything more complex than Select * from MyTable where x = y John Weller 01380 723235 07976 393631 > > John, > Change all your joins on t

RE: SQL Problem

John, Change all your joins on the Suppliers and Locations tables to be "left Joins" not "inner joins". Dave Crozier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Weller Sent: 22 January 2008 22:22 To: profox@leafe.com Subj

Re: SQL Problem

Does the problem occur if you use 0 (zero) instead of EMPTY in the IIF? - Original Message From: John Weller <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Tuesday, January 22, 2008 7:22:00 PM Subject: SQL Problem Hi Guys, I have a problem that is driving me nuts! I have 2

SQL Problem

Hi Guys, I have a problem that is driving me nuts! I have 2 tables holding details of stock movements, referred to as Transactions, TransHeader and TransDetails. TransHeader holds details of the transaction type, TransType, which can be Goods In (GI), Transfer (TF) or Goods Out (GO). There are

Re: SQL Problem

On 27 Jun 2007 at 16:57, Jeff Johnson wrote: > I am doing a SELECT statement in VFP7: > > SELECT * FROM _dcdb INTO CURSOR csrdcdb WHERE VAL(tripdate) > > lnbegin GROUP BY LEFT(tripdate, 6) I think the problem (as John was saying) is that you have to GROUP BY a field in the resulting ta

RE: SQL Problem

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of john harvey > Sent: Wednesday, June 27, 2007 5:01 PM > To: [EMAIL PROTECTED] > Subject: RE: SQL Problem > > I think you need something that is being aggregated in the select

RE: SQL Problem

Subject: SQL Problem I am doing a SELECT statement in VFP7: SELECT * FROM _dcdb INTO CURSOR csrdcdb WHERE VAL(tripdate) > lnbegin GROUP BY LEFT(tripdate, 6) _dcdb is a free table and I am getting an error SQL Column Activatecell no found. There is nothing anywhere t

SQL Problem

I am doing a SELECT statement in VFP7: SELECT * FROM _dcdb INTO CURSOR csrdcdb WHERE VAL(tripdate) > lnbegin GROUP BY LEFT(tripdate, 6) _dcdb is a free table and I am getting an error SQL Column Activatecell no found. There is nothing anywhere that says "Activatecell".