Re: query too Complex

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Gerben
Sure, I can stuff it with random data. How many rows do you want? Are you
inserting complete emails, binary chars if any?
-Anders

"Gerben Kessen" <gerben.kessen(@)wantit.nl> wrote in message
news:ecNfZddSFHA.1972@xxxxxxxxxxxxxxxxxxxxxxx
> 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
> >> >> > -----------------------------------------------------------
> >> >> >
> >> >>
> >> >>
> >> >
> >>
> >>
> >
>
>

.

Relevant Pages

  • Re: Calling mail() in a loop
    ... this is my first post and I have found this list very ... > resourceful for me so far. ... > reasons). ... > call that would be a similar test without having to send out emails. ...
    (php.general)
  • Various Problems with OE that may be one basic problem?
    ... This is my first post, and I am mentioning several different things ... Inbox pane changes on it's own to have frames and a scrollbar to ... Doesn't send emails to newsgroups. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Calling mail() in a loop
    ... this is my first post and I have found this list very ... I have built a small system to allow my clients to send out permission ... emails to their customers from a MySQL db. ... Chris Bruce ...
    (php.general)
  • can user-sent emails be "secretly" forwarded to me as administrator?
    ... hi, this is my first post here, but was wondering if it is possible to ... have all the emails from one user on my computer sent to me without ... i have seen how i could forward all incoming mail to ... the "sent" folder. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • can user-sent emails be "secretly" forwarded to me as administrator?
    ... hi, this is my first post here, but was wondering if it is possible to ... have all the emails from one user on my computer sent to me without ... i have seen how i could forward all incoming mail to ... the "sent" folder. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)