Search:

Type: Posts; User: Garret Mott

Page 1 of 80 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    6
    Views
    88

    Re: "Phantom" Recnum?

    Probably should've - but I'm already bats.
  2. Replies
    6
    Views
    88

    Re: "Phantom" Recnum?

    Hi Sture -

    The client migrated it - I believe with whatever driver came with 19.1. What's strange is that on my machine, the table explorer does not show the recnum column - just the client's.
    ...
  3. Replies
    6
    Views
    88

    Re: "Phantom" Recnum?

    This is the other way 'round & MS SQL (Express). DF Shows recnum, SSMS does not.

    My MySQL experience is with the Mertech driver & in 5+ years never had an issue adding/updating fields through the...
  4. Replies
    6
    Views
    88

    "Phantom" Recnum?

    Hi -

    Df19.1 - embedded converted to MS SQL via studio tools. There is a system file (single record) that in the DF Table Explorer shows Recnum. However, in SQL, there is no Recnum column. DF...
  5. Replies
    10
    Views
    220

    Re: ValidationTable Sorting

    Hi Phil -

    A customer prefers a combo with Y and N ovr a checkbox - so this code is all over their system. Y always shows first.


    Object oWSComboForm1 is a ComboForm
    ...
  6. Re: Simple unconditional constraint not working

    Actually, it's a boolean property - hence the "pb". I'd misremembered that what it does is to show/hide a form that let's the user select a particular location.
  7. Re: Simple unconditional constraint not working

    My own code - the property holds a Yard Location used to limit the SL to records for just one location. I should've removed that line.

    And - each time the SL is fired up, it checks the property...
  8. Re: Simple unconditional constraint not working

    yup - what Michael said - set wherever you need the non-default - otherwise it'll use the default.
  9. Re: Simple unconditional constraint not working

    Hi -

    This is the 'tother way 'round - but the same idea. Put this in the calling form:



    Procedure Prompt_Callback Handle hoPrompt
    Forward Send Prompt_Callback...
  10. Replies
    8
    Views
    155

    Re: cDbTextEdit Enabled_State

    I can confirm that Stephen's workaround does indeed work.

    Now remembering the old thread(s) is not something I can help on. What was your name again?
  11. Replies
    8
    Views
    155

    Re: cDbTextEdit Enabled_State

    Have you tried the (old) Object_Shadow_State? Set to True to disable. In 19.0 neither works for me (Object_Shadow_State or Enabled_State).

    There's also pbNoEnterReadOnly - set to True to disable...
  12. Replies
    16
    Views
    329

    Re: Do as I say, don't do as I do...

    This might (or might not) be appropriate here - but y'all know I don't always filter... Besides, it's Friday afternoon!


    https://www.youtube.com/watch?v=mYKWch_MNY0
  13. Re: Simple unconditional constraint not working

    Different strokes... I find I want it True most of the time. :)
  14. Re: Simple unconditional constraint not working

    We've all been bitten by it :)
  15. 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...
  16. 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...
  17. Replies
    3
    Views
    124

    Re: Trying to uninstall DF20.0 fails

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

    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...
  19. Replies
    7
    Views
    173

    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.
  20. Replies
    2
    Views
    110

    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" -...
  21. Replies
    17
    Views
    376

    Re: Datetime to Date?

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

    Re: Datetime to Date?

    But my 'murican is real good.

    :p
  23. Replies
    17
    Views
    376

    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.
  24. Replies
    17
    Views
    376

    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...
  25. Replies
    6
    Views
    241

    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.
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4