I am using Liveocde Indy 9.0 and am trying to use Windows DLL via livecode external I have Visual Studio 2017 and used the following article which seems a little dated. I could use some insight and help to get it to work.
I am stuck with not being able to actually invoke the funciton that the example talk about. In Livecode I am getting an error invoking the external function. I have PATHs setup in PATH variable as well through the External Helper. I have also updated the Windows SDK tool to reflect the SDK version 10 and not the version 8.0 as prescribed in the tutorial.
Anyone out there worked successfully with calling functions in Windows DLL? I have Windows 10
livecode. wikia . com/wiki/Working_with_DLL
Windows DLL Help
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Re: Windows DLL Help
Hi Azim,
welcome to the forum!
I had a look at the lesson and it is made for LC 2.4xxx, so it is not only outdated, but completely out-of-date. And it was meant to create a windows DLL from scratch and never meant for any interaction between LC and existing Windows DLLs!
I am not an expert, but I tink the days of creating and using DLLs for specialized tasks in LC are over, once LC introduced "Livecode Builder" in LC 8.
Please open the dictionary, select "Guide" on the topleft corner, scroll to "Extending Livecode" and start reading. That is the future of LC!
Best
Klaus
welcome to the forum!
I had a look at the lesson and it is made for LC 2.4xxx, so it is not only outdated, but completely out-of-date. And it was meant to create a windows DLL from scratch and never meant for any interaction between LC and existing Windows DLLs!
I am not an expert, but I tink the days of creating and using DLLs for specialized tasks in LC are over, once LC introduced "Livecode Builder" in LC 8.
Please open the dictionary, select "Guide" on the topleft corner, scroll to "Extending Livecode" and start reading. That is the future of LC!
Best
Klaus
Re: Windows DLL Help
Did you read this post? https://livecode.wikia.com/wiki/Working_with_DLL
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w
Re: Windows DLL Help
Yes, he is referring to exactly this lesson in his intitial posting!MaxV wrote: ↑Wed Jul 11, 2018 1:00 pmDid you read this post? https://livecode.wikia.com/wiki/Working_with_DLL
Re: Windows DLL Help
Time ago, Ken Ray posted instructions to use a Non-LiveCode DLL with LiveCode
(named Revolution, back then):
http://www.sonsothunder.com/devres/live ... ext002.htm
There are many other useful tips in his website:
http://www.sonsothunder.com/devres/live ... vecode.htm
(named Revolution, back then):
http://www.sonsothunder.com/devres/live ... ext002.htm
There are many other useful tips in his website:
http://www.sonsothunder.com/devres/live ... vecode.htm
DataGrid-TextEncoding-SQLSERVER
The Collation on the SQLSERVER database that I am using is SQL_Latin1_General_CP1_CI_AS
My Query to extract the customer table is as below. When I hardcode something like lastname like 'F%' it is working. Whenever I am using the search field for userinput, the datagrid is empty. I understand it is a TextEncoding issue, I simply dont know how to encode the tFirstName and tLastName local variables.
Thank you in advance
put "select lastname, firstname from customer" into tQueryString
set itemdel to tab
put item 1 of tSearchString into tFirstName
put item 2 of tSearchString into tLastName
put "%" after tLastName
put "% " after tFirstName
put " where lastname like " & "'" & tLastName & "'" & " and first name like " & "'" & tFirstName & "'" after tQueryString
..
..
// Connect to the Database
put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVER=" & gServer & ";DATABASE=" &gdatabase & ";UID=" & gUsername & ";PWD=" & gPassword & ";Trusted_Connection=No",,,) into tConnID
set the dgData of group "Customer DataGrid" to empty
put revdatafromQuery(,,tConnID,tQueryString)into theDataGridArray
set the dgText of group "Customer DataGrid" to theDataGridArray
My Query to extract the customer table is as below. When I hardcode something like lastname like 'F%' it is working. Whenever I am using the search field for userinput, the datagrid is empty. I understand it is a TextEncoding issue, I simply dont know how to encode the tFirstName and tLastName local variables.
Thank you in advance
put "select lastname, firstname from customer" into tQueryString
set itemdel to tab
put item 1 of tSearchString into tFirstName
put item 2 of tSearchString into tLastName
put "%" after tLastName
put "% " after tFirstName
put " where lastname like " & "'" & tLastName & "'" & " and first name like " & "'" & tFirstName & "'" after tQueryString
..
..
// Connect to the Database
put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVER=" & gServer & ";DATABASE=" &gdatabase & ";UID=" & gUsername & ";PWD=" & gPassword & ";Trusted_Connection=No",,,) into tConnID
set the dgData of group "Customer DataGrid" to empty
put revdatafromQuery(,,tConnID,tQueryString)into theDataGridArray
set the dgText of group "Customer DataGrid" to theDataGridArray