Search found 426 matches

by AxWald
Tue Nov 18, 2014 2:38 pm
Forum: Databases
Topic: sql 2008 connection
Replies: 3
Views: 1634

Re: sql 2008 connection

Hi, create a system dns on your machine, to the SQL server. Use this one in your connection, and it will work. I you want to connect via Internet, be sure that, for the SQL server, port forwarding is enabled (on the router). Be careful with this - I'd not really want to have an SQL server exposed to...
by AxWald
Sat Nov 15, 2014 8:52 pm
Forum: Databases
Topic: Advice Needed
Replies: 24
Views: 6376

Re: Advice Needed

Sadarahu, reading all of this thread I seem to get a feeling what you're after. Plz excuse if I should be wrong, and ignore my post then. From your usage of the term "forms" I assume a background in MS Access, or similar. The kind of database front ends that shows tables, helps you creating queries,...
by AxWald
Sat Nov 15, 2014 11:49 am
Forum: Databases
Topic: Importing data into SQLite from csv
Replies: 11
Views: 3381

Re: Importing data into SQLite from csv

Hi, I might be missing the point, but I do it this way: (evil pseudo-code!) put "INSERT INTO 't_Orders' ('CST', 'PCT', 'SEC', 'ART', 'APR', 'AMG','ORV') VALUES " into MyStr //Starting an SQL string // ... now using a loop to populate the values; and closing the ready SQL string put revDataFromQuery(...
by AxWald
Wed Nov 05, 2014 5:33 pm
Forum: Databases
Topic: INSERT INTO MySQL (Decimal 10,4) - ???
Replies: 2
Views: 1627

INSERT INTO MySQL (Decimal 10,4) - ???

Hi, Assume it just another brain block - I need to insert/ update/ upsert data into a MySQL database, and having a field there that is formatted [Decimal 10,4] makes me trouble. I keep getting errors of this field, I have tried all possible ways of numberformat and format now, but it still doesn't w...
by AxWald
Thu Oct 16, 2014 3:22 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: POS kick drawer
Replies: 31
Views: 7442

Re: POS kick drawer

Hi, revPrintText numToByte(27)&numToByte(112)&numToByte(48)&numToByte(25)&numToByte(250) Have you tried it with spaces? " revPrintText numToByte(27) && numToByte(112) && ... " ? And maybe with " numtochar " instead of " numtobyte "? Another thing, dunno if you can address/ map the printer to a COM: ...
by AxWald
Thu Jul 24, 2014 2:43 pm
Forum: Linux
Topic: Prerequisites for a StandAlone on Linux?
Replies: 3
Views: 1595

Re: Prerequisites for a StandAlone on Linux?

Awesomeness!

How could I forget to check this information?
This is a start now, and it looks nerdy enough to present it to my "coding chieftain".
Let's see what he'll answer.

Thx a lot, have fun!
by AxWald
Thu Jul 24, 2014 11:09 am
Forum: Linux
Topic: Prerequisites for a StandAlone on Linux?
Replies: 3
Views: 1595

Prerequisites for a StandAlone on Linux?

Hi, I have to ask for your knowledge and your experience - I have to persuade the "coding chieftain" of another company to get an LC-App of mine installed on his highly-customized Linux gadgets. So I'll at first explain what my App will look like: A standalone with a helper stack ("start using stack...
by AxWald
Tue Jul 15, 2014 1:13 pm
Forum: Databases
Topic: Connect to a .mdb database
Replies: 2
Views: 1507

Re: Connect to a .mdb database

Hi, as I understand this example is for SQL Yoga, and you'd need to have this installed ... "dbconn" isn't in my LC dictionary ... As I understand, again, ODBC requires certain drivers to be installed, and proper DSN's configured (matching the special driver version ...). There's code examples out t...
by AxWald
Tue Jul 15, 2014 10:30 am
Forum: Databases
Topic: show returned data from query into fields
Replies: 17
Views: 4004

Re: show returned data from query into fields

Hi, can you explain it better? Access comes in 2 versions - a fully enabled version, sporting all features, and the mentioned free downloadable runtime version , meant to only work as, well, a runtime. I quote from "Details" in the above link: The Access 2007 Runtime is similar to previous runtimes ...
by AxWald
Sat Jul 12, 2014 7:16 pm
Forum: Android Deployment
Topic: [Q] Connect to remote MS-SQL-Server?
Replies: 10
Views: 4723

Re: [Q] Connect to remote MS-SQL-Server?

Hi, Is it possible with livecode to connect from an android app to a remote MS-SQL -Server? (See the bold words ...) I may be wrong, but I think you'll be forced to use ODBC (of which I don't know yet if it's available on Android). For sure, your MS-SQL server must have TCP/IP registered (not only n...
by AxWald
Fri Jul 11, 2014 11:10 am
Forum: Databases
Topic: show returned data from query into fields
Replies: 17
Views: 4004

Re: show returned data from query into fields

Hiya! [...] curiously the query builder button it's always grayed out. I tried to turn-on it unsuccessfully. Don't you get something like this? Access_Query.jpg Then you might have an Access Runtime version :/ (The upper part is where you can show tables, link them at your desire, designate the fiel...
by AxWald
Thu Jul 10, 2014 12:18 pm
Forum: Databases
Topic: show returned data from query into fields
Replies: 17
Views: 4004

Re: show returned data from query into fields

Hi, one more question: there is some tutorial or guide about databases management? (e.g. queries with variables, filling fields with returned data, ect.) all I found on LiveCode Lessons refers to very simple situations of limited use in the real world. As you write in your first post you're working ...
by AxWald
Wed Jul 09, 2014 2:26 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Lineoffset() finding line beginnings?
Replies: 2
Views: 471

Re: Lineoffset() finding line beginnings?

Hi,
Klaus wrote:HI axwald,

the trick is to "cheat" a bit:
...
Thx so much! This forum is actually completely insanely awesome!

Have a good time!
by AxWald
Wed Jul 09, 2014 2:14 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Lineoffset() finding line beginnings?
Replies: 2
Views: 471

Lineoffset() finding line beginnings?

Hi, something is blocking my brain. I searched the dictionary, I googled at my best knowledge, nothing found. Maybe some kind soul can help me with a one-liner? Problem: I have a locked field (MyFld), that contains multiple lines of entries. I have an input field, and whenever something is written i...
by AxWald
Sat Jul 05, 2014 4:52 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: retrieve livecode code from standalone desktop app
Replies: 28
Views: 4949

Re: retrieve livecode code from standalone desktop app

Hi, If you made [...] your stanadalone with the Community version You SHOULD be able to open the standalone with a text editor and retrieve the code. Having said that; I tired just now and got in a right mess :/ Just opened a small standalone.exe (3MB+) in my editor and searched for "mouseup". A few...

Go to advanced search