Search results for query: *

  1. T

    Updating GridView with Database Changes

    I have Gridview Control bound to SqlDataSource control. When I click Edit button I go out to another form to edit underlying Sql Database . After saving changes to database how do I get Gridview to refresh and show latest change? I've tried Gridview.DataBind() with no success. Need assistance...
  2. T

    Passing Structure to Function

    Forgot to mention that the PF function uses File/Field parameter defining File Number and Field number. No need to use structures for data layout on each file. We have 70 files managed this way. Our File Table defines file Name, Field Type, Offset and Field length. So PF...
  3. T

    Passing Structure to Function

    Call we use is same a yours: Declare Function BTRCALL Lib "w3btrv7.dll" (ByVal Opcode As Short, _ ByVal Cursor() As Byte, _ ByVal DataBuffer As IntPtr, _ ByRef DataBufferLength As Short, _ ByVal KeyBuffer() As Byte, _ ByVal KeyLength As Short, _ ByVal KeyNum As Short) As Short We have created...
  4. T

    Passing Structure to Function

    I believe I was investigating working with FairCom database when I posted question. It's a dead issue at this time. I'll be happy to answer any btrieve questions you may have. Lee
  5. T

    Passing Structure to Function

    I have some code I'm converting from VB6 and am experiencing problem passing a structure to a function call parameter. Function dataBuffer (DB) parameter in VB6 is passed "AS ANY" Declare Function BtrCall Lib "wbtrv32.dll" Alias "BTRCALL" _ (ByVal OP%, _ ByVal PB$, _ db As Any, _...
  6. T

    UPDATE WHERE Clause with Parameters

    Tom: Thank you - Lee
  7. T

    UPDATE WHERE Clause with Parameters

    Tom: Thank you very much. That solves the problem. Lastly, if doing an UPDATE how do I determine if the WHERE clause fails? For Example if I'm updating record 44 (WHERE RECNUM=44) and record 44 does not exist - how do I trap that? can't seem to figure that out and Try/Catch doesn't see the...
  8. T

    UPDATE WHERE Clause with Parameters

    John: Ok -Yes, I'm using Access 2007 Database and since you said parameters must match those in the query and my query is... StrSql = "UPDATE Equipment SET TimeStampCol =@TimeStampCol," & _ " Ident =@Ident, Descr =@Descr, Serial=@Serial, Cost=@Cost" & _ " WHERE Recnum =@RecNum" The Where...
  9. T

    UPDATE WHERE Clause with Parameters

    Wow... Seems like an awful lot of work just to fix a WHERE clause. Don't get me wrong, I do appreciate all comment but I'm trying to lean how to use basic Parameters right now so I'd rather stick with what I've got and what I understand right now before going to Stored Procedures. I can...
  10. T

    UPDATE WHERE Clause with Parameters

    Yes, it is displaying a valid number and that number is also in the database. If intRecnum is 2 and if I were to use WHERE RecNum=2 it will work but it doesn't like the parameterization of @Recnum Also, in my code example, how do I determine in code if update was successful or no record found...
  11. T

    UPDATE WHERE Clause with Parameters

    The following code does not find record to be updated. If however I change WHERE Recnum=@RecNum to WHERE Recnum=1 and remove parameters referencing @Recnum it will update record 1. What am I doing wrong here? StrSql = "UPDATE Equipment SET TimeStampCol =@TimeStampCol," & _...
  12. T

    Adding TimeStamp

    Thanks for the help - I'm just doing some practice work with parameters trying to learn basics of ADO.NET. I changed column name TimeStamp to TimeStampCol in my SQL and Database to solve the problem. Lee
  13. T

    Adding TimeStamp

    Have Access Database and "TimeStamp" field defined as Date/Time Data Type. In my VB.Net Code I get error on ExecuteNonQuery saying that "Syntax error in INSERT INTO statement." If I remove the code relating to TimeStamp program runs without error. I have read that there's some problem with...
  14. T

    Using Help Files

    Am migrating VB6 to VB.Net and am stuck once again. We use App.HelpFile in vb6 to set Path and Filename of current help file. Current help File can change depending on which form is displayed. How do we assign help files in VB.net? Sample VB6 Code: Sub SetHelp(NewHelp As Integer) 'Set...
  15. T

    Converting VB6 to VB.Net

    Thanks for confirming my suspicion. Lee
  16. T

    Converting VB6 to VB.Net

    Am converting a VB6 project to VB.Net and need help with "AS ANY" type declaration in a function declaration. Example: Declare Function BtrCall Lib "wbtrv32.dll" Alias "BTRCALL" (ByVal op%, ByVal PB$, db As Any) as integer I know As Any is invalid in VB.Net Most of the calls to this...
  17. T

    updating VB6 project using OCX components

    Have been working with VB6 for 10+ years and now must convert some programs to .Net. Can I use my existing OCX components or must I re-design my entire user interface? I know there is a "Code Advisor" that will scan my code and suggest ways to use inline code with .NET but concern is calls to...
Back
Top