PowerBASIC Peer Support Forums
 

Go Back   PowerBASIC Peer Support Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.08 seconds.
Search: Posts Made By: Mike Doty
Forum: Source Code Jul 24th, 2015, 12:47 PM
Replies: 3
Views: 1,070
Posted By Mike Doty
No concatenation building string array

slGetArray - returns result string array and counts
slGetArrayShort - shorter version, use parsecount/ubound

Faster than slSelAry when all columns are not needed.
Routines could be modified to...
Forum: Programming the Internet Jul 18th, 2015, 01:16 PM
Replies: 3
Views: 289
Posted By Mike Doty
Thanks George that fixed it, but now if the...

Thanks George that fixed it, but now if the firewall is on get TCP Timeout in the server log at startup of SQLiteningServer.exe (which is a service.)
The Windows firewall never asks about the...
Forum: Programming the Internet Jul 18th, 2015, 03:50 AM
Replies: 3
Views: 289
Posted By Mike Doty
Computer name was resolving to 127.0.0.1 (localhost)

Computer name was resolving to 127.0.0.1 instead of 192.168.1.3.
There is no hosts file and using windows 7 32-bit.
It is working now, but think one or more of the commands below fixed it.

The...
Forum: Programming Jul 16th, 2015, 08:00 PM
Replies: 17
Views: 1,466
Posted By Mike Doty
The simple solution is to install 32-bit Windows...

The simple solution is to install 32-bit Windows anything in another partition and use multi-boot.
Many machines running 32-bit Windows 7 SP1 or higher will get a free download of Windows 10...
Forum: Dynamic Dialog Tools (DDT) Jul 16th, 2015, 10:35 AM
Replies: 6
Views: 390
Posted By Mike Doty
CASE %WM_INITDIALOG ...

CASE %WM_INITDIALOG
'initialization code
DIALOG POST CB.HNDL, %WM_USER+500, 0, 0
CASE %WM_USER+500
'initialization code to load GUI and continue...
Forum: PowerBASIC Console Compiler Jul 14th, 2015, 12:58 PM
Replies: 16
Views: 1,787
Posted By Mike Doty
and createprocess ... ...

and createprocess ...

http://www.powerbasic.com/support/pbforums/showthread.php?t=42128

http://www.powerbasic.com/support/pbforums/showthread.php?t=42721
Forum: PowerBASIC for Windows Jul 12th, 2015, 12:24 PM
Replies: 10
Views: 405
Posted By Mike Doty
Binary searches (much faster with sorted data) ...

Binary searches (much faster with sorted data)
http://www.powerbasic.com/support/pbforums/showthread.php?p=480187
Forum: PowerBASIC for Windows Jul 12th, 2015, 12:20 PM
Replies: 26
Views: 2,291
Posted By Mike Doty
4 different methods. Added ARRAY SCAN.

'
#DIM ALL 'binary searches require array be sorted SEARCHES.BAS
'These 4 tests produce the same results.
'First,/last element number found is returned and are times using TIX.
'
'Search ...
Forum: Cafe PowerBASIC Jul 12th, 2015, 08:12 AM
Replies: 5
Views: 686
Posted By Mike Doty
Are there reasons to develop using a Windows...

Are there reasons to develop using a Windows Server version?
Do these Windows servers come with built-in virtualization so 32-bit
and 64-bit application can be tested without rebooting?

Does...
Forum: PowerBASIC for Windows Jul 11th, 2015, 09:01 PM
Replies: 26
Views: 2,291
Posted By Mike Doty
3 different methods. Searches.bas

'
#DIM ALL 'binary searches require array be sorted SEARCHES.BAS
'These 3 tests produce the same results.
'First/last element number found is returned and time taken using TIX.
'
'Search ...
Forum: PowerBASIC for Windows Jul 10th, 2015, 09:47 PM
Replies: 26
Views: 2,291
Posted By Mike Doty
Exact match including all duplicates

FUNCTION binaryfindrange (x() AS STRING, _
searchfor AS STRING, _
First AS LONG, _
Last AS LONG) AS LONG
...
Forum: PowerBASIC for Windows Jul 8th, 2015, 02:46 PM
Replies: 10
Views: 405
Posted By Mike Doty
Get range using Array Scan

'Get range of elements in a sorted array matching length of search string
'Getting only first and last element gives range to process
'Useful to process duplicates or scan in on closest match...
Forum: Programming Jul 7th, 2015, 04:16 AM
Replies: 195
Views: 4,924
Posted By Mike Doty
Sorting 2,000,000 100-byte records should take 7...

Sorting 2,000,000 100-byte records should take 7 or 8 seconds. but John found an error in ARRAY SORT with his test file.

Demonstrate time to sort any number of records

%Records = 2000000...
Forum: Programming Jul 6th, 2015, 01:18 PM
Replies: 33
Views: 809
Posted By Mike Doty
Yes, that would work. I was reading VIEWs are...

Yes, that would work.
I was reading VIEWs are not stored procedures and cannot update, delete or insert, but they can cause a trigger.
This might help performance if the view is on the server side...
Forum: Programming Jul 6th, 2015, 07:49 AM
Replies: 15
Views: 1,129
Posted By Mike Doty
Could this be done with a browser control? ...

Could this be done with a browser control?
http://www.powerbasic.com/support/pbforums/showthread.php?t=51208
Forum: Programming Jul 5th, 2015, 06:26 AM
Replies: 33
Views: 809
Posted By Mike Doty
How would you design using a trigger? I like...

How would you design using a trigger?
I like triggers, but when one doesn't work I find it a bit difficult to see what caused the error.

The logic below fires the trigger with each line item....
Forum: Programming Jul 3rd, 2015, 01:57 PM
Replies: 33
Views: 809
Posted By Mike Doty
Michael's suggestions should work with SQLite. ...

Michael's suggestions should work with SQLite.

Integer primary won't work because multiple rows is another discussion.
Here are some other ways to get the next highest invoice number.

drop...
Forum: Programming Jul 3rd, 2015, 11:48 AM
Replies: 33
Views: 809
Posted By Mike Doty
If the column was integer primary key...

If the column was integer primary key autoincrement would assure next highest number even after a vacuum:

drop table if exists t1;
create table t1(c1 integer primary key autoincrement);
insert...
Forum: Programming Jul 3rd, 2015, 05:50 AM
Replies: 33
Views: 809
Posted By Mike Doty
As I'm sure you are aware that Edwin has/is...

As I'm sure you are aware that Edwin has/is unfortunately quiting programming.
http://sites.nofeeshost.com/hellobasic/261/

Have you tried SQLitening? http://www.sqlitening.com
Forum: Programming Jul 3rd, 2015, 05:28 AM
Replies: 33
Views: 809
Posted By Mike Doty
Verify spaces are not saved using length function...

Verify spaces are not saved using length function

drop table if exists t1;
create table t1(c1 num);
insert into t1 values( 123 );
select length (c1) from t1;

3
With no Type specified
Forum: Programming Jul 3rd, 2015, 05:05 AM
Replies: 33
Views: 809
Posted By Mike Doty
Probably don't need to convert string to number...

Probably don't need to convert string to number using VAL and then convert back to string. TRIM$ should be enough?

MACRO sNum(MyString) = TRIM$(STR$(VAL(MyString)))
$comma = ","
FUNCTION PBMAIN...
Forum: Programming Jul 2nd, 2015, 02:40 PM
Replies: 33
Views: 809
Posted By Mike Doty
There is no error in SQLite. The conversion...

There is no error in SQLite.
The conversion from text to numeric works without single quotes and
also with datatypes INT, NUM, INTEGER, NUMBER.

drop table if exists t1;
create table t1(c1 num);...
Forum: Programming Jul 2nd, 2015, 01:15 PM
Replies: 33
Views: 809
Posted By Mike Doty
I've gotten INT NUM INTEGER NUMBER to work. Is...

I've gotten INT NUM INTEGER NUMBER to work.
Is there possibly a non-numeric character in the insert value?
A comma, dash, space ...
Forum: Programming Jul 2nd, 2015, 11:22 AM
Replies: 33
Views: 809
Posted By Mike Doty
Michael, You are correct. I went back and...

Michael,
You are correct.
I went back and redefined columns as NUMERIC and INTEGER
and it did produce the correct results when inserting using single quotes.

Karl,
Did you drop the table and...
Forum: Programming Jul 2nd, 2015, 11:16 AM
Replies: 33
Views: 809
Posted By Mike Doty
SQLite will favor a column defined NUMERIC,...

SQLite will favor a column defined NUMERIC, INTEGER or REAL, but will accept anything.
The input was single quoted.
https://www.sqlite.org/datatype3.html
Showing results 1 to 25 of 500

 
Forum Jump

All times are GMT -4. The time now is 02:03 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Copyright 1999-2011 PowerBASIC, Inc. All Rights Reserved.
Error in my_thread_global_end(): 1 threads didn't exit