Re: [MSEide-MSEgui-talk] MSE* & PostgreSQL

2013-01-21 Thread Ivanko B
PostgreSQL ODBC driver is usually set up : ftUnknown maps to ftLongText(ftText). -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills curre

Re: [MSEide-MSEgui-talk] MSE* & PostgreSQL

2013-01-21 Thread Ivanko B
Though.. it can be mapped as ftText is mapped - for the initial approach. -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with

Re: [MSEide-MSEgui-talk] MSE* & PostgreSQL

2013-01-21 Thread Ivanko B
Does "as char(nn)" not work? "select cast(id as char(36)) as id, [..]" ? It should work but : 1) cumbersome syntax (the simplier "id::char(36)" can't be used because of the ":" char used for parameters) 2) non-optimal search ---

Re: [MSEide-MSEgui-talk] MSE* & PostgreSQL

2013-01-21 Thread Martin Schreiber
On Tuesday 22 January 2013 06:37:25 Ivanko B wrote: > Can MSEgui datsets & widgets handle ftUUID filed type > (16*(2*ASCII_ALPHA_NUM)) ? > Do you mean ftGuid? > CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public; // PG 9.1+ > > CREATE TABLE t1 ( > id UUID NOT NULL DEFAULT uuid_generat

[MSEide-MSEgui-talk] MSE* & PostgreSQL

2013-01-21 Thread Ivanko B
Can MSEgui datsets & widgets handle ftUUID filed type (16*(2*ASCII_ALPHA_NUM)) ? CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public; // PG 9.1+ CREATE TABLE t1 ( id UUID NOT NULL DEFAULT uuid_generate _v1(), [ ...] ); ---

Re: [MSEide-MSEgui-talk] *** MSEgui has own classes and db units

2013-01-21 Thread Graeme Geldenhuys
On 01/21/13 06:00, Ivanko B wrote: > Branching with merging & stashing is nightmare to understand :) Why? If you pull new changes, make sure you don't have any local modifications which could cause a conflict while pulling. So, simply stash your changes, then do a pull. Same applies to merging. A