Re: read from a MS SQL server with 4D

As I have said before Microsoft's own web site. See below is a great resource https://docs.microsoft.com/en-us/sql/sql-server/sql-server-technical-documentation Regards Chuck Chuck Miller Voice: (61

Re: SFTP - Native to 4D?

If you look in the archive you will find examples of using applescript to do this Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmill

Re: 4D v16 issues

You might but be aware if you use cross table reports in quick reports, they are not as yet available in 64 bit client. If you compile 64 bit server and 32 bit client on macs you use the new network layer Regards Chuck

Re: Love 4D's math interpretation...

Are just discovering this this has been 4D since version 1.x. Math precedence is only with parens. That is why I often perform calculations on multiple lines. Make it easier to read Regards Chuck

Re: What to do about users who won't follow instructions?

Yes this is true but tips who do not remember history are doomed to repeat it. A person who consistently does not read instructions fully and then complains may never. Just remember they are customer and tell them you will have to bill them if they continue to not follow instructions, as this wa

Re: What to do about users who won't follow instructions?

OK how about another option Implement foot runner ? and send a file to execute. One line of instructions. Here run this! Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-106

Re: SQL Pivot

In 4D? I have not looked but don;t believe it is implemented. If using SQL server try the following web site for help https://technet.microsoft.com/en-us/library/ Regards Chuck --

Re: 4D Client as Web Server - How to monitor

Couldn’t you launch a server process and look for web server running on a client? I don’t use web server so don’t know if a name or what name is there. but if it is you can find out if running already Additionally I believe execute on client does exist. Not sure but you could launch a server pr

Re: 4D v16.2 false record locks

I assume he flew Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 USA Registered 4D D

Re: Export import all after a crash

Or you could use in error call and simply skip the bad records. I would also try opening I. C/S and use sql to fill a me empty data file you can use same on error stuff. Regards Chuck Sent from my iPhone > On Oct 22, 2017, at 1:20 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: >

Re: Primary Key in 4Dv15

If you are not too far along I would consider not using 4Ds built in method to create these keys. I and others have posted code to do this. Second you can check tables to ignore primary keys but that means data will not be backed up for those tables Regards Chuck Sent from my iPhone > On Oc

Re: Tip: Exporting to a target folder in a package

Why would you let users put stuff in resources folder. The problem is if you are on client server client adds to resource folder how do you get document to server when you next deliver version to client resource gets overwritten when connecting to a new version Chuck Sent from my iPhone > O

Re: Primary Key in 4Dv15

Sorry I disagree create new key fields in v15 with empty data file just don't use built in stuff roll your own. Then when you open real data file all will work as expected. You can not make type of uuid before v15 as far as I know Regards Chuck Sent from my iPhone > On Oct 24, 2017, at 6:22 P

Re: Primary Key in 4Dv15

OK this works in one way. However, if you have a primary key named something else it will fail use the following code to return primary key column number C_LONGINT($0;$1;$TableNumber_L) $TableNumber_L:=$1 $Primary_key_field_id_L:=-9 C_TEXT($ConstraintID_txt) C_LONGINT($Primary_key_field_id_L) Be

Re: identify duplicates

As has been recommended distinct values is your friend but it really depends upon what you mean by duplicates. For example Charles and Karl are the same name but in different languages. So what do you mean by duplicates. Also is case important or do able and Able equal each other Regards Chuck

open gmail in browser from 4D

Hi All 4d Version 15.x. I want to be able to open a new mail message when company uses google mail in a browser window. Google hosts their domain. Has anyone done this. I need a solution for macs and windows. Has anyone done this. I have tried open URL and it only opens Mail on my mac. Not sure

Re: SQL error

Hi all I have noted in the past that fn calls fail when you have an existing method turn it into fn call and r5un unless you restart. If you create a new method and mark as fn no restart is needed. Regards Chuck ---

Re: v13 - installing plugin

what plug and how compiled? perhaps it is not compatible with v13. Have you tried with a new bank data base? Regards chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232

Re: LEP - and Batch files

You may have to escape the spaces in the path name Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brook

Re: 4D v6.8

You can contact 4d Sales they can give you an ftp address. If this does not work, email me directly and I will look at my old CDs from 4D Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed S

Re: 4D v6.8

I think that machine is much too new I used to keep a really old machine around just for that but gave up Regards Chuck Sent from my iPhone > On Nov 14, 2017, at 11:16 AM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > my old (1st version of MacBook Air has on it) That just migh

Re: Drop Down Menu Form Event

I would always use on clicked for drop downs, combo boxes, check boxes, buttons, radio buttons. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

mirror set up

Hi All, we are finally going to implement mirrors at one of my clients. For a variety of reasons, we are not going to use soap. I was thinking of the following options 1. One main machine create new log, copy to shared volume Now I can branch Option 1. Create a second text file that the mirror

Re: localisation (again)

Much better than my choice which was substring till the period and then num Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinfor

Re: Twin Process for 4D SQL Data Source

I have not but it seems to me to be a lot of work as you will have to get data/orrays/variables between processes and it would also seem to me that you could choose only one to put in a new process Regards Chuck --

Re: Securing ODBC Connections?

Not sure we need more info. Is the ODBC driver 32 or 64 bit. If you put a trace in sql authentication method and see what happens. Can you connect from excel? Access is a little out of the ordinary for me have never tried to access 4D from it Regards Chuck Sent from my iPhone > On Jan 2, 201

Mirror design question

Hi All, environment v15 production machine mac Mirror windows box I have a table that is used to control cron jobs. I can do one of the following 1. Not include this table in journal so it never moves to the mirror. 2. Add a field to the table that is text (Production or Mirror) If I do this a

Re: "Are you sure you want to open the structure file in read only mode" - Windows 7

I always install directly on c:/My apps name folder/My app Fir built servers. I even have had trouble running off C drive at all, so i have taken to installing on a second drive. Regards Chuck Ch

Re: Object focusable/tabable properties

Do you want some one to be able to click in and not tab. If not you could use on enter event and deal with what you want cursor to do and where it should move to Regards Chuck Chuck Miller Voice: (6

Re: SMTP error 10113 Error with Authentication

when using gmail at least you need the SMTP_Auth ($smtp_id_l;MAIL_UserName_s;MAIL_Password_s;2) to have the additional param (2) to match with smtp port 587 which is secure Hope this helps Regards Chuck

Re: Document capture

Yes the O/S is fine but if you ever want to open the folder on a PC or MAC be prepared to wait. The more files the longer the wait. At least that has been my experience Regards Chuck Sent from my iPhone > On Jan 25, 2018, at 3:35 PM, Peter Bozek via 4D_Tech <4d_tech@lists.4d.com> > wrote:

Re: The writing is on the wall

Unless something has changed, it is not just plug ins quick report on 64 does not support cross tab reports Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-

Re: Problem with PDF Creation into Temporary Folder

It also depends upon when doc was created. Sometimes the O/S needs time to update itself. I have found that occasionally I have created a document and I have to wait via a repeat loop that looks like this Create document DocFound_B:=false repeat delay process(current process;60) test to see of d

Re: [v16-Mac] Syntax check hits me with 3,300 + Errors...

When you do that be careful to set your preferences otherwise all numbers will be typed as real Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmill

issue with MSC

Hi All, Environment Mac OS X 10.11.6 4D version 15.5 and 15.4 hf2 I have tried to run using both version. I run mac check and it tells me there are anomalies and to open th log file created, which I do nothing appears in safari or chrome or firefox. Any ideas as to what I can do tho fix this

Re: v13 Compiled vs Interp execution

As an aside I would use a local variable so command would look like this c_real($MyNumber_R) $MyNumber_R:=500.0 $real:=2*(MAXLONG-$MyNumber_R) I do this so that 4D does not reset results based upon what it thinks it should do I think it will work even without the .0 Regards Chuck -

Re: Remember password

Not that I have found, but you can remove saved passwords at every log in which has the same result Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Import from Excel

No need to export. Save as a text file and you can import that Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions

Re: When your Extreme router is too slow... (5N)

I am using an Asus router and am very happy with it. There is a third party guru who is always patching and fixing. I am not on a gig network but constantly get wireless speeds close to what my sip (RCN) provides Regards Chuck

Re: Room available at the Grand Hyatt Washington

we feel your pain Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 USA Registered 4D Developer

windows script issue

Hi All, I need to run a command line script on windows to retrieve a password. I have filled a text variable to use with launch external process and set to pasteboard. When I run from cmd prompt. I get expected results but when tun from launch external process I get nothing no in, no out no err

Re: 4D 15.5 on MacOs High Sierra 10.13.4

Try creating another account on the same machine and see what happens. You could also delete all 4D preferences and see if that changes the situation Chuck Chuck Miller Voice: (617) 739-0306 Informe

Re: windows script issue

OK I get it. How can I turn this into a bat file that returns a value? as it works from command prompt Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617

Re: A thought on re-indexing of a large database after repairs, compacting etc

OK I don;t get it. We have a data base of over 200 Gig with many millions of records. We run using SSD,s in an Areca RAID. 1 Terabyte SSDs. I can tell you that when we restored from a backup up and rebuilt indices it took not more than 20 minutes to so. It does not matter if it is by table or no

FN call issues

Hi all, Environment 4D 15.6 windows server running 32 bit mac 4D running 32 bit version of 4D I log into server using sql and run code that looks like text_txt:=select {fn MethodName() as text from [tablename] into :global variable;” sql login begin sql execute immediate : text_txt; end

Re: Picture Buttons in v16

This is the code we used //Method: dev_convertPicLibToJPEG //Description //convert picture library pictures to JPEG for upgrade to v16 - set transparent background // Parameters // If (User in group(Current user;"Design Access Group")

Re: Help with SQL login

Are you sure that 1. SQL server is running 2. you are trying to connect to same place Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjm

setting up mirror

Hi All, I am finalizing code to set up a mirror and then an emergency server. I have two trains of thought, both of which use a shared folder to move the log file into Option 1 Create a second text file after the journal has been copied and on the mirror, have a process that runs every x minut

Re: stylized text

HI Thanks for the info. I think it would be a great idea to put this in the documentation, as it is far from intuitive. This is especially true when working from the first character in the text. I for one would never see that there was a space counted in position one even though t did not really

connect to a pervasive sql database

Hi All, Has anyone done this. I am looking to select some data from a table and import into customer 4D database so as to mark invoices paid. Is the driver only available for windows or is there a UNIX version that can be used on a MAC Thanks and regards Chuck --

query issue

env v 15.x I have the following set up order table order line table related auto to order invoice line table related auto to order line packing list table related auto to invoice one table I have the following queries QUERY([Order];[Order]Order_ID=$OrderIDS_aL{$Loop_L}) // on record found $OH_C

Mirror and backup

Hi All, I am just writing and testing code to have a mirror server and have a few questions 1. I assume that we will be backing up mirror on a daily basis? Does this cause any problems? 2. If we try and integrate a log file when backup is running what happens? 3. If we are integrating a log f

Re: v13+ Progress component, and other components

What happens if you check this method as shared. Remember you are running in your own process. Not sure if this does anything. Regards Chuck Sent from my iPhone > On Jun 11, 2018, at 10:21 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > closing the progress object > (user_C

select from _USER_COLUMNS

Given the following code select COLUMN_NAME, DATA_TYPE, DATA_LENGTH, COLUMN_ID from _USER_COLUMNS where TABLE_ID = :$TableNumber_L into :$Cname_atxt, :$DataType_aL, :$DataLength_aL, :$ColumnID_aL; What values can be returned in $DataType_aL It seems that they do not equal 4D data types (I d

Re: Delay process bug

What does that mean? If you have a cron job process running on server that wakes every 5 minutes to check and launch other processes. Is that what you consider short term scheduling? Regards Chuck

Re: Updating a structure - data goes AWOL

How about using sql to bring data from old database into new one Regards Chuck Sent from my iPhone > On Jun 14, 2018, at 8:36 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I'm updating a client's database from an old version of my app, in 4D v12, > to the latest version, usi

issue on windows 10 and 4D 15

Hi All, I have one windows ten machine where pictures of buttons do not display properly. They do on all other instances. We have deleting local files, reinstalling 4D, to no avail. Any ideas out ther greatly appreciated Thanks and regards. Chuck --

Re: issue on windows 10 and 4D 15

Buy that will be a lot of work. I would guess I can run code to change all pict to pngs in the library. I do not think it is just one form. That is the problem BTW the right click and changes did not seem to work Regards Chuck ---

Re: Time Machine error -8003 when restoring 4D structures

It does. How about using 4d backup and then backing that up.You could run it every hour on your structure only. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

Re: Delay process bug

i use delay process for years with no issues, however, I do not think I ever delay for more than 15 minutes. Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Uppercase Lowercase

If using sql you can select case sensitivity, but be careful, as it will be set for every sql query where clause Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617)

crashing issue in v15 and v16

Hi All, In light of the wingdings issue on windows ten, I wrote the following two methods Please note that if you have a write pro are on a form, the bolded line crashes on Macs every time. I have tried v15.6, v16r6 both 32 bit and 64 bit Hope these help someone else out Regards Chuck Begin u

Re: RIP Sujit Shah

Also, not sure I ever met him, but my thoughts and prayers are with his family Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-s

Re: 4D Write licensing...

Whether editing or printing, the user needs a license Regards Chuck Sent from my iPhone > On Jun 28, 2018, at 3:47 PM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I appreciate your response; however, this does not answer my question. If I > have one license and the 4D Wr

Re: problems with SEND RECORD

OK If you are going to do this, why not go all the way C_LonGINT($RECORDSINTABLE;$ALLRECORDS;$NOTAPPROVED;$APPROVED) $RECORDSINTABLE:=RECORDS IN TABLE([Approvals]) > ALL RECORDS([Approvals]) > ALLRECORDS:= Records in selection([Approvals]) SET QUERY DESTINATION(INTO VARIABLE;$NOTAPPROVED) QUERY([A

Re: Converting pictures on 4D forms (Windows) to get transparency

Add the line after convert TRANSFORM PICTURE($vPict;Transparency;0x00FF) Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.c

Re: Objects without Stylesheets suddenly displayed as Wingdings!

I have code that will report on any object on forms with no font or style sheets assigned Please advise if you want it Regards Chuck Sent from my iPhone > On Jul 11, 2018, at 10:44 PM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I've not ever seen this before today, when I wa

subtables issue

Hi All, I have a situation I have not encountered and am stumped. I have been asked by a person to upgrade pictures in a v17 db. When I open the structure, I still see subtables there. I also see the tables that have been created as part of conversion. What gives? The new tables appear to be th

v16 & 17 components and plugins

Hi All, I am starting upgrade and can not see to find the following in install image 4D POP 4D Pack Any ideas where that they might be, or have they been deprecated Thanks and regards Chuck Chuck

Re: 4DIC - Hiding the authentication username in outgoing emails

I would think not. That probably is against google rules or any email that needs authentication. Think of it this way. You have a gmail account and authenticate but you want to send email as someone else and hide who you are. Sounds like spammers dream You could send all from one email and cha

Re: 13.x Quick Report Export Max Output File Size?

What OS are you running it could be an OS limit Regards Chuck Sent from my iPhone > On Jul 24, 2018, at 12:13 PM, Benedict, Tom via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > I'm exporting data from 4D to a text file using the 4D Quick Report Editor in > v13.x. It stopped writing to disk wh

Re: Does MSC database compact work for large data files?

I do not think this will work any longer because A. Indices that point to related records and on related records can not be turned off B. A primary key or in fact any key that is set as unique must have indexing turned on Sometimes it is better to use sql to recreate data file. Now that v16 ha

Re: Assistance Needed

If you are a partner call your sales person Regards Chuck Sent from my iPhone > On Jul 27, 2018, at 1:14 PM, Robert McKeever via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > A client wants his ancient (4D 2003) database upgraded to 4D v16. > > I have the source, and a 10.6.8 environment under

Re: Confused about ORDA

Nope it always worked this way. If you have * at end of line and do not identify what query format will be & (and) is assumed This QUERY([T_Loggers_data];[T_loggers_readings]FK_REAP=[REAP_sections]FK_REAP;*) QUERY([T_Loggers_data];[T_Loggers_data]TLD_timestamp>=$TSsectionSta

Re: Changes to variable initialization in v16?

In my opinion it is. It is too easy to make changes with unexpected results. for one. Security for another re control of source code. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solut

Re: Fields Missing Getters and setters

You can use sql to identify which are primary keys for each table and use sql to set primary key Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: v13 - marking field as 'Primary Key'

You can identify primary key with the following code $TableLoop_l is table number Begin SQL SELECT CONSTRAINT_ID FROM _USER_CONSTRAINTS WHERE TABLE_ID = :$TableLoop_l AND CONSTRAINT_TYPE = 'P' INTO :$ConstraintID_txt; SELECT COLUMN_ID FROM _USER_CONS_COLUMNS WHERE CONSTRAINT_ID = :$ConstraintID_t

Re: height and width of a fixed prtinted object

Thanks that did it not sure how I missed it as I looked at the command in documentation Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Export/ImportSQL

Hi pat I have out code to clone data in v11 at one of summits. If you install that code it should get all data for you. I am in Alaska on vacation so can not get I for you till I return. Please advise if you have it. Regards Chuck Sent from my iPhone > On Aug 20, 2018, at 1:22 PM, Pat Ben

Re: New record numbering system and CALL WORKER

OK i have done this many times with a table. You have multiple records in the table, one for each id you need. I usually make that records key name ([table]field). If you have to keep track of released numbers, you can add a blob field. I would not be adding object fields as you can not access u

Re: New record numbering system and CALL WORKER

It does, but remember if you already have multiple transactions, you will have to keep track and may have to suspend that many times Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Soluti

Re: New record numbering system and CALL WORKER

Thanks. As I said I was not sure. Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 U

Re: 4D Write Pro WP feature request - need your support

I also have one client that is a huge 4d write user. We also need to have ability to convert to Microsoft word. Additionally, there are some things we do not seem to be able to do in write pro so for now, we will be maintain 4d write licenses across multiple servers and standalone dos. At the la

Re: Isolating the Cause of a Server Crash

Are you running any virus detective on that machine. If so you should skip 4D folders Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cj

list box entry issue

Hi All, Environment 4D v15.6 client server I have an array based list box where there are 3 arrays. Only array 3 can be entered Under the list box object I have the following code Case of : (Form event=On Load) //EDIT ITEM(DefaultValue_ar;1) : (Form event=On Double Clicked) C_LONGINT($Colu

Re: PDF generation on Windows - Latest Thinking

I think it does run on windows 10 Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 US

Re: v13 - SQL alter table, what is wrong?

I missed th v13 part. Is the field already set as indexed and unique. If not I would bet alter table would not work. I do not know what would happen in newer versions if you tried to assign UUID inside 4D without it being a UUID field Have you tried other data types. Regards Chuck ---

Re: v13 - SQL alter table, what is wrong?

I think it should be ALTER TABLE [Anmlprot_File_Link] ADD [Journal_Key] [Primary KEY] This is from the 4D docs ALTER TABLE sql_name {ADD column_definition [PRIMARY KEY] [TRAILING] | DROP sql_name | ADD primary_key_definition | DROP PRIMARY KEY | ADD foreign_key_definition | DROP CONSTRAINT sql_n

button picture problems in v16 and v17

Hi All, I am using user mode component created many moons ago. I have updated my input forms and now none of the pictures for the buttons show up. The input forms are of course in the host db. Buttons on those forms are inside the images folder and appear during editing. I have copied the same

Re: button picture problems in v16 and v17

Actually source was available. I have it. Fixed the issues I was having. I did look at the tech note and the link for Miyako’s component was broken so any ideas where I might find it Thanks and regards Chuck ---

scrolling issue on v15 and still on v16

Hi All, I have a output form (Not list box). This was created many moons ago in v 3. with multi lines. In one table we have close to 2 million records. I know no one would do this in real life but during testing if you scroll down toward the bottom, all look fine. If you go to end or someplace

Re: Notes on converting pictures to v17

Yup after your CONVERT PICTURE($vPict;$codec) You need the next line of code TRANSFORM PICTURE($vPict;Transparency;0x00FF) --

v 17 r release

Hi All, I thought I saw a post that v17 R 2 was available for download and can’t find it. I would like to download Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, I

Volume shadow copy v17

Hi All, Has anyone implemented this feature and tested to make sure it works as advertised. Thanks and regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: What causes a record to be Locked but Locked By has no info?

Kirk In 15 I had found you could lock records think you unlocked them and then unloaded but they would remain locked until you quit server. What happens in your car if you select a different record. Do both show as locked only first or only the second Regards Chuck Sent from my iPhone > O

Re: What causes a record to be Locked but Locked By has no info?

> > :(Locked($table_p->)) > > // do the locked record stuff > > End case > > > Sure I can manipulate the records between locked and unlocked. The thing is > when I do those sorts of operations everything behaves as expected. This is > some sort of edge case,

Re: 4D v17 R2 Object Library Write Pro Toolbar

I did the same thing what a bumber Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 USA Registered 4

Re: What causes a record to be Locked but Locked By has no info?

You should test for is in read only mode and if so unload record/ set to read write and then load Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064

Re: Resetting the table sequence number

You could also do this c_longint($Variable_L) begin sql select MAX([table]ID_Field) from [table] into :$Variable_L; end sql or query by sql([table];max([table]ID_Field) into :$Variable_L) I am not sue query by sql will work Regards Chuck ---

Re: Custom Object Libraries crash 4D V16.4

I think there is 32 bit windows server as well Regards Chuck Sent from my iPhone > On Oct 16, 2018, at 5:29 PM, Julio Carneiro via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Well, this is on Windows, so server is 64-bit and client is 32-bit. No other > options. > >> On Oct 16, 2018, at 6:

  1   2   3   4   >