Search:

Type: Posts; User: Garret Mott

Page 1 of 80 1 2 3 4

Search: Search took 0.12 seconds.

  1. Re: Deterine if an SQL statement failed or returned a warning ?

    I get it - that's where the Mertech command is excellent as it's precisely the next line after the Exec - though less informative on SPs than on selects/Updates/Inserts - but I think that's a MySQL...
  2. Re: Deterine if an SQL statement failed or returned a warning ?

    cConnection has an event called Error_Report - does that maybe do it? The help is not exactly full of info on what it does (sorry Dennis! ;))

    I'm afraid I'm more familiar with the Mertech driver...
  3. Replies
    3
    Views
    83

    Re: Trying to uninstall DF20.0 fails

    You can check out any time you like, but you can never leave...
  4. Replies
    2
    Views
    88

    Re: Timespan error

    Thanks Vincent. I figured it was something like that, but thought it'd be nice if it could handle the blank date situation. No big deal, as I have a workaround.

    While this is probably more of a...
  5. Replies
    7
    Views
    141

    Re: Navigating in Database Explorer

    If you are in non-edit mode - do NOT do this when the grid is editable! - you can type a value & press any of the find keys. If the column is in the chosen index, it should find it.
  6. Replies
    2
    Views
    88

    Timespan error

    This may have already been reported, but I'll do it anyway ;)

    DF 20.0.7 DAW SQL Driver MS SQL Express


    Move (dtNow - dtCalibrated) to tsDiff


    dTNow is today & dtCalibrated is "blank" -...
  7. Replies
    17
    Views
    331

    Re: Datetime to Date?

    It's all aboot the fun... A Candahoodian correcting an Amurrican on English is definitely humoUrous.
  8. Replies
    17
    Views
    331

    Re: Datetime to Date?

    But my 'murican is real good.

    :p
  9. Replies
    17
    Views
    331

    Re: Datetime to Date?

    Your English is WAY better than my Italian. :)

    Do you have a field named "ref"? That's what's giving the error - that the default value for it is invalid.
  10. Replies
    17
    Views
    331

    Re: Datetime to Date?

    Hi -

    I think you'll see that the DF side thinks the 3 red arrow ones are dates & the green arrow is a datetime.

    I think you'll find that changing the DF type from Date to DateTime will cure the...
  11. Replies
    6
    Views
    218

    Re: Credit Card Payment

    I agree with Chuck. Pick a processor that does all the entry/storage on their system & only returns a confirmation code so you know it went through OK.
  12. Replies
    3
    Views
    137

    Re: A good read !

    But agile has such great jargon! Makes one sound really cool dontcha know?

    OK, back to the scrum so I can get ready for the sprint. ;)
  13. Re: Call a named function from a database field value

    Eval?

    Move (Eval(table.field)) to...

    Or Get (Eval(table.field)) of ...
  14. Replies
    3
    Views
    179

    Re: Client wants color changes

    Hi Jim -

    I think we need more info. You want to change the application? The view? forms? Yellow text for labels, for entry?
  15. Re: Any place to obtain Dataflex install files or 3.5 diskettes for DOS computers?

    3.2 will compile & run 2.3 code - so it should work, no?
  16. Replies
    19
    Views
    511

    Re: DateTime accuracy

    So - in later versions it is safe to "Move (CurrentDateTime()) to dDate" - where dDate is a date variable?

    I don't have a specific issue - I simply stopped doing it & changed existing code back to...
  17. Replies
    19
    Views
    511

    Re: DateTime accuracy

    Maybe it's changed, but in 19.0, there were issues using CurrentDateTime with dates & it was suggested to only use it with DateTime variables.

    ??
  18. Replies
    19
    Views
    511

    Re: DateTime accuracy

    Didn't know it was obsolete - but yes - it always works - but if you need time in the same field you have to write code to build a datetime.
  19. Replies
    19
    Views
    511

    Re: DateTime accuracy

    Thanks to both Samuel & Edgard. I will take the easy way out & since this is a recnum table (who know?) - I'll just add that to the index.

    It would be nice to get a definitive answer though - as...
  20. Replies
    19
    Views
    511

    Re: DateTime accuracy

    Thanks Samuel. I too made the same change & got the same results. Maybe there's some other setting?

    Roughly 30% of the values have 00 for the seconds & none have milliseconds - though the...
  21. Replies
    19
    Views
    511

    Re: DateTime accuracy

    Can anyone verify that it's local settings that affect the precision of datetimes? If so - is there any way I can ensure a certain precision?

    It seems something has changed on machines that...
  22. Replies
    19
    Views
    511

    Re: DateTime accuracy

    No, I haven't in detail. I did check on the server, but it saves seconds - it's just some user machines - which are on both VDI's and actual Win10 boxes. Since it does save seconds on the server,...
  23. Replies
    19
    Views
    511

    Re: DateTime accuracy

    I don't know either. I'm just going by what the help says + how many are saved with no seconds. All are saved with "Set Field_Changed_Value Field SBS_FUP.FollowUpTime to (CurrentDateTime())" in...
  24. Replies
    19
    Views
    511

    DateTime accuracy

    Hi -

    DF 19.0, MySQL, Mertech Driver

    I am using a DateTime as part of an index & it seems that some computers recently started "not saving" the seconds portion. So - the DateTime is 05-02-2022...
  25. Replies
    14
    Views
    375

    Re: Decimal Separator

    I certainly did not mean to make light of this - as it is an issue that would be nice to get squared away. Seems DR handles this differently than DF.

    In addition, DR has a same number variable...
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4