Re: query too Complex
- From: "Gerben Kessen" <gerben.kessen(@)wantit.nl>
- Date: Mon, 25 Apr 2005 22:41:34 +0200
mmm... Ok thanks for your help I'm afraid that I have to make a
workaround.... btw have you tried to store a large amout of data in the
table(s)?
Gerben.
"Anders Altberg" <x_pragma@xxxxxxxxx> wrote in message
news:u9KqCFYSFHA.248@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Gerben
> I actually made a new database and created the two tables MaliingEmail and
> Email, with all the columns listed in your view query. I then copied your
> CREATE VIEW statement from Outlook Express to my Command window and ran
> it.
> No problem creating the view or using the view.
> -Anders
>
> "Gerben Kessen" <gerben.kessen(@)wantit.nl> wrote in message
> news:eLbwQ8PSFHA.1096@xxxxxxxxxxxxxxxxxxxxxxx
>> Thanks again for your post.
>> But that's not the case. What I wrote in my first post. This statement is
>> working in vfp9 but only when I zap the tables or when I only select 1
> field
>> .... and .... it is still working in VFP7..
>>
>> Strange isn't it ?? Sys(3055) does not make any difference btw.
>>
>> Gerben.
>>
>>
>>
>> "Anders Altberg" <x_pragma@xxxxxxxxx> wrote in message
>> news:%238phPVPSFHA.3972@xxxxxxxxxxxxxxxxxxxxxxx
>> > Hi Gerben
>> > There's nothing wrong with the create view command as such; it worked
> for
>> > me
>> > in VFP9. Are you running this as a macro or trying to store the whole
>> > shebang in a string literal. In that case it's to long, 325 bytes where
>> > the
>> > maximum length of a string literal is 255.
>> > -Anders
>> >
>> > "Gerben Kessen" <gerben.kessen(@)wantit.nl> wrote in message
>> > news:u#x#qbDSFHA.204@xxxxxxxxxxxxxxxxxxxxxxx
>> >> This is the query:
>> >>
>> >> create view mvMailingEmail as ;
>> >> SELECT MailingEmail.id,MailingEmail.iEmail, MailingEmail.iPerson,
>> >> MailingEmail.iReservation,MailingEmail.dSent, MailingEmail.cEmaillog,
>> >> MailingEmail.iMailing,email.cEmailAddress as cEmailAddress;
>> >> FROM MailingEmail join Email on Email.id=MailingEmail.iEmail;
>> >> WHERE MailingEmail.iMailing=?lid
>> >>
>> >> The error is 1845
>> >>
>> >> Gerben.
>> >>
>> >> "Stefan Wuebbe" <stefan.wuebbe@xxxxxx> wrote in message
>> >> news:%23F%23ubU1RFHA.1176@xxxxxxxxxxxxxxxxxxxxxxx
>> >> >
>> >> > "Gerben Kessen" <gerben.kessen(@)wantit.nl> schrieb im Newsbeitrag
>> >> > news:uJNC%23kxRFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
>> >> >> Hi,
>> >> >>
>> >> >> I have some pretty large tables, about 2.000.000 records, creating
>> >> >> a
>> >> >> simple view which joins the tables gives an SQL query too
>> >> >> complex...
>> >> >> When I zap the table it works as expected. When I remove some
> fields
>> >> >> from the select it sometimes works
>> >> >> And... when I compile it in VFP7 it works without any problem.
>> >> >
>> >> > Hi Gerben,
>> >> > Which error number do you get? in Vfp9 only?
>> >> > Would Sys(3055) help?
>> >> >
>> >> >
>> >> > hth
>> >> > -Stefan
>> >> >
>> >> >
>> >> >
>> >> > --
>> >> > |\_/| ------ ProLib - programmers liberty -----------------
>> >> > (.. ) Our MVPs and MCPs make the Fox run....
>> >> > - / See us at www.prolib.de or www.AFPages.de
>> >> > -----------------------------------------------------------
>> >> >
>> >>
>> >>
>> >
>>
>>
>
.
- Follow-Ups:
- Re: query too Complex
- From: Anders Altberg
- Re: query too Complex
- References:
- query too Complex
- From: Gerben Kessen
- Re: query too Complex
- From: Stefan Wuebbe
- Re: query too Complex
- From: Gerben Kessen
- Re: query too Complex
- From: Anders Altberg
- Re: query too Complex
- From: Gerben Kessen
- Re: query too Complex
- From: Anders Altberg
- query too Complex
- Prev by Date: Re: Question about GRID
- Next by Date: Re: SourceSafe issues continued
- Previous by thread: Re: query too Complex
- Next by thread: Re: query too Complex
- Index(es):
Relevant Pages
|
