Jump to content

SuperDaveCybtro

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

SuperDaveCybtro's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. So the SQL turns out to actually work. I just verified it. But it is a royal hog. Is there a better way to check these values, then what I am doing?
  2. Hello All. I am trying to convert a query I have working fine in M$access to MySql. In access I have one table linked 4 times to allow me to compare 4 different date values to 4 different fields. This will let me check that all dates have valid data. If it passes this test I want it to append a record to my statuses table. My Problem is that Though it works in Access Even converting it thus far it does not work in MYSQL. All it says is that the Query could not be executed. I am not sure what other information you need but I will provide much as I can. [code] INSERT INTO tblstathist ( rqstid, userid, statusid ) SELECT tblrqst.RqstId, 1447, 8 FROM tblperiod,     tblperiod tblperiod_1,     tblperiod tblperiod_2,     tblperiod tblperiod_3,     tblrqst,     vewcurrentstat WHERE vewcurrentstat.statusid = 4 AND   tblperiod.PeriodBeginProcessing<=now() AND   tblperiod_1.PeriodBeginProcessing<=now() AND   tblperiod_2.PeriodBeginProcessing<=now() AND   tblperiod_3.PeriodBeginProcessing<=now() AND   tblperiod.PeriodDate = tblrqst.RqstP1Stop AND   tblperiod_1.PeriodDate = tblrqst.RqstP2Start AND   tblperiod_2.PeriodDate = tblrqst.RqstP1Start AND   tblperiod_3.PeriodDate = tblrqst.RqstP2Stop AND   tblrqst.RqstId = vewcurrentstat.rqstid; [/code]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.